Re: Re: [BUGS] Return value error of‘to_timestamp’

From: Aleksander Alekseev <a(dot)alekseev(at)postgrespro(dot)ru>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: 甄明洋 <zhenmingyang(at)yeah(dot)net>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Re: [BUGS] Return value error of‘to_timestamp’
Date: 2016-08-04 15:03:09
Message-ID: 20160804180309.28bd486a@fujitsu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>> postgres=# select to_timestamp('1990-1-1 11:11:11.123456789',
>> 'YYYY-MM-DD HH24:MI:SS.US'); to_timestamp
>> -------------------------------
>> 1990-01-01 11:13:14.456789+08
>> (1 row)
>> postgres=#

> ​Working as designed...​

Maybe it means that current design is poor. However since this behavior
is documented there are users who might depend on it. So I doubt it
will be changed any time soon.

Though I wonder maybe we should consider introducing a new set of
time-related procedures with different behavior (to_timestamp_strict?),
that would be more obvious to users.

--
Best regards,
Aleksander Alekseev

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2016-08-04 15:06:40 Re: [BUGS] Re: [BUGS] Return value error of‘to_timestamp’
Previous Message huang 2016-08-04 14:54:57 About hash index question