Re: Migration from DB2 to PostgreSQL-TIMESTAMP(arg1,arg1) - Mailing list pgsql-general
| From | Daniel Cristian Cruz |
|---|---|
| Subject | Re: Migration from DB2 to PostgreSQL-TIMESTAMP(arg1,arg1) |
| Date | |
| Msg-id | CACffM9GNwB-_YQguGW=O1-32oBUfRg=roxGaGRtFKG8cmrdQgQ@mail.gmail.com Whole thread Raw |
| In response to | Re: Migration from DB2 to PostgreSQL-TIMESTAMP(arg1,arg1) (Raymond O'Donnell <rod@iol.ie>) |
| Responses |
Re: Migration from DB2 to PostgreSQL-TIMESTAMP(arg1,arg1)
(sachin kotwal <kotsachin@gmail.com>)
|
| List | pgsql-general |
I've done something weird:
CREATE OR REPLACE FUNCTION "timestamp"(_date date, _time time) RETURNS timestamp AS $$
SELECT _date + _time;
$$ LANGUAGE sql;
SELECT "timestamp"('2013-01-01'::date, '12:00:00'::time);
It worked, but you will need explict cast and quote the timestamp function name... Many people would not like this.
2013/6/27 Raymond O'Donnell <rod@iol.ie>
On 27/06/2013 12:51, sachin kotwal wrote:If you're trying to convert a string to a timestamp as in your first
> I have done some more try as follows:
>
> #select timestamp(current_date);
> ERROR: syntax error at or near "current_date" at character 18
> STATEMENT: select timestamp(current_date);
> ERROR: syntax error at or near "current_date"
> LINE 1: select timestamp(current_date);
> ======================================================
email, you probably want to_timestamp():
http://www.postgresql.org/docs/9.2/static/functions-formatting.html
Otherwise, current_timestamp and friends produce the current date & time:
http://www.postgresql.org/docs/9.2/static/functions-datetime.html
HTH,
Ray.Raymond O'Donnell :: Galway :: Ireland
>
> #SELECT TIMESTAMP(to_date('2013-01-01','YYYY-MM-DD'));
> ERROR: syntax error at or near "to_date" at character 18
> STATEMENT: SELECT TIMESTAMP(to_date('2013-01-01','YYYY-MM-DD'));
> ERROR: syntax error at or near "to_date"
> LINE 1: SELECT TIMESTAMP(to_date('2013-01-01','YYYY-MM-DD'));
> ======================================================
>
> select timestamp(current_date,current_time);
> ERROR: syntax error at or near "current_date" at character 18
> STATEMENT: select timestamp(current_date,current_time);
> ERROR: syntax error at or near "current_date"
> LINE 1: select timestamp(current_date,current_time);
> ======================================================
>
> #SELECT TIMESTAMP(to_date('2013-01-01','YYYY-MM-DD'),'17:15:43'::time);
> ERROR: syntax error at or near "to_date" at character 18
> STATEMENT: SELECT
> TIMESTAMP(to_date('2013-01-01','YYYY-MM-DD'),'17:15:43'::time);
> ERROR: syntax error at or near "to_date"
> LINE 1: SELECT TIMESTAMP(to_date('2013-01-01','YYYY-MM-DD'),'17:15:4...
>
>
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/Migration-from-DB2-to-PostgreSQL-TIMESTAMP-arg1-arg1-tp5761389p5761390.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
--
rod@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Daniel Cristian Cruz
クルズ クリスチアン ダニエル
pgsql-general by date: