Horton

Thread

  1. Datetime -> Timestamp conversion

    Christof Petig <christof.petig@wtal.de> — 1999-08-25T10:03:07Z

    Your name               :      Christof Petig
Your email address      : christof.petig@wtal.de

System Configuration
---------------------
  Architecture (example: Intel Pentium)         : dual Intel Pentium II

  Operating System (example: Linux 2.0.26 ELF)  : Linux 2.2.11 ELF

  PostgreSQL version (example: PostgreSQL-6.5.1):   PostgreSQL-6.6
(yesterday's cvs)

  Compiler used (example:  gcc 2.8.0)           : egcs-1.1.1

Please enter a FULL description of your problem:
------------------------------------------------
christof=> select timestamp(datetime 'now');
ERROR:  No such function 'datetime_stamp' with the specified attributes

christof=> select timestamp(abstime(datetime 'now'));
timestamp
-----------------------------
Wed Aug 25 11:54:23 1999 MEST
(1 row)

It looks like if the SQL parser needs 'datetime_timestamp' , it looks
for 'datetime_stamp' which doesn't exist!

christof=> select datetime_timestamp(datetime 'now');
datetime_timestamp
----------------------
1999-08-25 11:55:46+02
(1 row)

Also all the different output formats for date/time are more than
confusing.
I read that TIMESTAMP (SQL92) shall replace DATETIME (PostgreSQL) in the
future, has anybody signed this work, yet? Thomas Lockhart?