 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 2 matches |
| Author | Message |
|---|---|
 Topic: Date validation through DB2 query |
|
| Arun Sundaramoorthy Replies: 11 Views: 16596 |
 Forum: Database Posted: Fri May 06, 2016 12:27 am Subject: It works but it not works,, strange !!! |
| Nic Clouston - I wanted to validate a large set of date stored in a char column, so I was looking for an alternate to ISDATE() function just a week back and google took me to this topic.
But none in ... |
|
| Topic: Date validation through DB2 query |
|
| Arun Sundaramoorthy Replies: 11 Views: 16596 |
Forum: Database Posted: Thu May 05, 2016 1:51 am Subject: Answer to how to valid if a content is a date or not in DB2 |
It can be done thru SQL mentioned below, hope it helps 
WITH TEMP (DATEE) AS (SELECT '160229' AS DATEE FROM SYSIBM.SYSDUMMY1) ... |
|
All times are GMT - 5 Hours |