| From: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
|---|---|
| To: | "Pedro B(dot)" <pedro(dot)borracha(at)netcabo(dot)pt> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Datetime |
| Date: | 2004-08-03 10:23:14 |
| Message-ID: | Pine.LNX.4.44.0408031319490.7249-100000@matrix.gatewaynet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
O kyrios Pedro B. egrapse stis Aug 3, 2004 :
> Hello,
>
> I'm using a TIMESTAMP column with a now() default which (correctly i
> assume) uses a 'yyyy-mm-dd hh:mm:ss' format.
Wrong!, timestamp does not use any human readable format to be stored.
Its not like MS* tools where dates/times are actually text.
now() returns the current UNIX (your running UNIX right?) timestamp which
in turn is
measured in seconds,miliseconds since the epoch.
i.e. 1970-01-01 00:00:00
>
> Is it possible to make it something like 'yyyy-mm-dd hh:mm:ss:cc' ?
> (basically, a DATE and a TIME, but with 2 decimal cases on the :cc and
> not .ccccc as the TIME format.
>
> Thanks,
> \\pb
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
--
-Achilleus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Glaesemann | 2004-08-03 10:56:56 | Re: Datetime |
| Previous Message | Pedro B. | 2004-08-03 07:22:51 | Datetime |