Advertisement
Advertisement
| 07.09.2008 at 12:09PM PDT, ID: 23551458 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: |
cast( case when cast(substring(convert(varchar(10), ttimeoffirstmetering, 108),1,2) as integer) > 12 then cast(substring(convert(varchar(10), ttimeoffirstmetering, 108),1,2) as integer)-12 when substring(convert(varchar(10), ttimeoffirstmetering, 108),1,2)='00' then 12 else cast(substring(convert(varchar(10), ttimeoffirstmetering, 108),1,2) as integer) end as varchar(10))+ case when cast(substring(convert(varchar(10), ttimeoffirstmetering, 108),1,2) as integer) > 12 then 'pm' else 'am' end as v_time |