| Date Functions [message #571896] |
Mon, 03 December 2012 10:32  |
mjm22
Messages: 44
Registered: January 2010
Location: Singapore
|
Member |
|
|
Hi All,
Trying to understand how Oracle DATE works and how it differs to TO_DATE in the below manner...
SELECT DATE '2012-10-25' FROM DUAL;
SELECT TO_DATE('2012-10-25','YYYY-MM-DD') FROM DUAL;
I've had a look through the Oracle Docs but can't find much on this. Basically I want to know how safe the first option is and if it does the same as the second.
Also, where does DATE get the Format String from (NLS setting?). Can it be employed to compare a literal with a date that has a TIME portion set to something other than 12:00:00?
Thanks
|
|
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
