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
‹
›
Home
View web version
No comments:
Post a Comment