Thomas Kellerer wrote:
>>> I asked this a while back already:
>>>
>>>select to_date('2013-02-31', '-mm-dd');
>>>
>>> will not generate an error (unlike e.g. Oracle)
>>
>> This is by design.
>
> When I previously asked this question the answer as "this is based on
> Oracle's to_date()":
>
On 01/20/2014 07:32 AM, Thomas Kellerer wrote:
Michael Nolan, 20.01.2014 16:17:
Thomas, try this:
'2013-02-31'::date
Thanks, I know this "works", but this can't be used if you have a non-ISO date
string
Hmm:
test=> SELECT '2013-02-31'::date;
ERROR: date/time field value out of range: "
Michael Nolan, 20.01.2014 16:17:
> Thomas, try this:
>
> '2013-02-31'::date
Thanks, I know this "works", but this can't be used if you have a non-ISO date
string
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgre
Albe Laurenz, 20.01.2014 15:29:
>> I asked this a while back already:
>>
>>select to_date('2013-02-31', '-mm-dd');
>>
>> will not generate an error (unlike e.g. Oracle)
>
> This is by design.
When I previously asked this question the answer as "this is based on Oracle's
to_date()":
http:
Thomas, try this:
'2013-02-31'::date
--
Mike Nolan
On Mon, Jan 20, 2014 at 7:44 AM, Thomas Kellerer wrote:
> Hi,
>
> I asked this a while back already:
>
>select to_date('2013-02-31', '-mm-dd');
>
> will not generate an error (unlike e.g. Oracle)
>
>
> However in the release notes of 9
Thomas Kellerer wrote:
> I asked this a while back already:
>
>select to_date('2013-02-31', '-mm-dd');
>
> will not generate an error (unlike e.g. Oracle)
This is by design.
> However in the release notes of 9.2.3[1] it is mentioned that
>
> - Reject out-of-range dates in to_date() (
Hi,
I asked this a while back already:
select to_date('2013-02-31', '-mm-dd');
will not generate an error (unlike e.g. Oracle)
However in the release notes of 9.2.3[1] it is mentioned that
- Reject out-of-range dates in to_date() (Hitoshi Harada)
I tried the above statement using 9
