![]() |
SELECT cast(A.due_DT as date format 'MM/DD/YYYY') as DueDt, A.BAL_AMT as Amount_Due,
03 Feb 2016
| 2 comments
,
|
![]() |
Hi, SELECT cast(CALENDAR_DATE as date format 'YYYY-MM-DD') - INTERVAL '1' YEAR FROM SYS_CALENDAR.CALENDAR
and get error 2666. Invalid dates supplied for CALDATE.
12 May 2014
| 2 comments
,
|
![]() |
I have timestamp values in Varchar field. Trying to populate this data in a table where field types are properly defined, and I am unable to push data from table a (timestamp is in varchar) to table b (where I want the date to be in timestamp field). Getting error message 2666. How can I find out fields with bad dates only?
13 Dec 2012
,
|