Re: Day of month defaults to 1 in TO_DATE

From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Fri, 08 Mar 2019 16:07:33 -0600
Message-ID: <8972285e628c9d3064a2fb7a0ee68586_at_society.servebeer.com>

On 2019/03/08 12:45, Andy Sayer wrote:

> https://docs.oracle.com/cd/E11882_01/server.112/e10729/ch4datetime.htm#NLSPG004
>
> "If you specify a date value without a time component, then the default time is midnight. If you specify a date value without a date, then the default date is the first day of the current month."
> It's documented in the globalisation guide at least
> I only managed to find it because I added "current month" to my google!

I bow before the greater googler!

Thanks, Andy!

Rich

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 08 2019 - 23:07:33 CET

This message: [ Message body ]
Next message: Rajesh Aialavajjala: "RAC 12.2 - Exadata X6-2 - Network Isolation between Databases - W/O VLAN tags"
Previous message: Andy Klock: "Re: RIP DDL Wizard"
In reply to Andy Sayer: "Re: Day of month defaults to 1 in TO_DATE"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message