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
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment