Tech Diary
September 13, 2017
One way of checking if date was formatted well
Date format expected: dd-MMM-yyyy. Example: 03-MAR-2017
WHERE condition:
....
and a_date is not null
and length(a_date ) = 11
and index(a_date , '-') = 3
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)