Re: Migration from DB2 to PostgreSQL-TIMESTAMP(arg1,arg1)

On 2013-06-27 20:43, sachin kotwal wrote:
> While migrating my application from DB2 to PostgreSQL.
>
> I want to migrate TIMESTAMP() function of DB2 into PostgreSQL.
>
> Example in DB2:
> #SELECT TIMESTAMP('2013-01-01','12:13:14') FROM SYSIBM.SYSDUMMY1
>
> 1
> --------------------------
> 2013-01-01-12.13.14.000000
>
>    1 record(s) selected.
> ==========================
>
> Example PostgreSQL:
>
> #SELECT TIMESTAMP('2013-01-01','12:13:14');
> ERROR:  syntax error at or near "'2013-01-01'" at character 18
> STATEMENT:  SELECT TIMESTAMP('2013-01-01','12:13:14');
> ERROR:  syntax error at or near "'2013-01-01'"
> LINE 1: SELECT TIMESTAMP('2013-01-01','12:13:14');
>
> After executing above SQL I am getting error.
>
> I checked definition of TIMESTAMP().
> It is as follows:
> test=# \df timestamp
>                                            List of functions
>     Schema   |   Name    |      Result data type       |         Argument
> data types          |  Type
> ------------+-----------+-----------------------------+--------------------------------------+--------
>   pg_catalog | timestamp | timestamp without time zone | abstime
> | normal
>   pg_catalog | timestamp | timestamp without time zone | date
> | normal
>   pg_catalog | timestamp | timestamp without time zone | date, time without
> time zone         | normal
>   pg_catalog | timestamp | timestamp without time zone | timestamp without
> time zone, integer | normal
>   pg_catalog | timestamp | timestamp without time zone | timestamp with time
> zone             | normal
> (5 rows)
>
> As we can see TIMESTAMP() hast two arguments date and time without time
> stamp but still it is giving error to me.
>
> Please reply if any suggestion.
>
>
>
>
> --
> View this message in context:
http://postgresql.1045698.n5.nabble.com/Migration-from-DB2-to-PostgreSQL-TIMESTAMP-arg1-arg1-tp5761389.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>

Hi,

# SELECT pg_catalog.timestamp('2013-01-01'::date, '12:13:14'::time);
       timestamp
---------------------
  2013-01-01 12:13:14
(1 row)