Thread: date/time function

date/time function

From

Sterpu Victor

Date:

01 December 2005, 08:08:25

I need a function that will transform from the format '2002-09-08
05:29:41' to seconds since 1970.

Thank you.

Re: date/time function

From

"A. Kretschmer"

Date:

01 December 2005, 08:17:58

am  01.12.2005, um 11:07:59 +0200 mailte Sterpu Victor folgendes:
> I need a function that will transform from the format '2002-09-08 05:29:41'
> to seconds since 1970.

scholl=# select now();
              now
-------------------------------
 2005-12-01 10:18:47.554236+01
(1 row)

scholl=# select extract (epoch from now());
    date_part
------------------
 1133428728.47011
(1 row)

scholl=# select extract (epoch from now())::int;
 date_part
------------
 1133428743
(1 row)



HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

Re: date/time function

From

Terry Lee Tucker

Date:

01 December 2005, 08:23:12

rnd=# select extract(epoch from timestamp '2002-09-08 05:29:41');
 date_part
------------
 1031477381
(1 row)

See the date/time functions documentation.

On Thursday 01 December 2005 04:07 am, Sterpu Victor saith:
> I need a function that will transform from the format '2002-09-08
> 05:29:41' to seconds since 1970.
>
> Thank you.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings