| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Bruno Boettcher <bboett(at)bboett(dot)adlp(dot)org> |
| Subject: | Re: How to typecast an integer into a timestamp? |
| Date: | 2012-01-28 15:15:19 |
| Message-ID: | 201201280715.19863.adrian.klaver@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Saturday, January 28, 2012 1:43:43 am Bruno Boettcher wrote:
> On Fri, Jan 27, 2012 at 08:17:37AM -0800, Adrian Klaver wrote:
> > Did some digging. php-mktime returns the Unix epoch (seconds since
> > January 1 1970 00:00:00 GMT)
>
> indeed, didn't get it that postgres timestamp wasn't the same....
Well internally they are stored that way. You just have to input the
values as some sort of time/date/timestamp string. For all the details see here:
http://www.postgresql.org/docs/9.0/interactive/datatype-datetime.html#DATATYPE-DATETIME-INPUT
>
> ciao
> Bruno
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2012-01-28 15:26:47 | Re: Multi master use case? |
| Previous Message | Bruno Boettcher | 2012-01-28 09:43:43 | Re: How to typecast an integer into a timestamp? |