Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
jaganreddy
Starting Member
10 Posts |
Posted - 2013-08-31 : 05:08:41
|
How to validate timestamp, i have tried so many time ,but iam not getting correct result, hwo to validate source data has timestamp or not ? i would like result s if the data is timestamp that should be 1, if the data is not timestamp that should be 0 ,iam using code like this................................................................ CASE WHEN TO_CHAR(OE_TECH_VLD_FROM_DTTM,'ddmonyyyy:hh:mi:ss.sssssss') then 1ELSE 0END..................................................................Thanks in AdvanceJagan |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|