F91320 JSSCHSTTIME Convert to Date using TSQL Script

wcheehing

Active Member
Hi, could anyone advice on how to convert the F91320 JSSCHSTTIME to a conventional Date (dd-mm-yyyy) using the TSQL Script.
Thanks.

WCH
 

marbus

Member
I Have the same doubt, i know that convertion is with a bussines fuction but if you have any way to convert this column it will amazing.

i hope your answer, thanks.

Saludos.
 

akkakm

Active Member
Try this, this works for SQL Server
-- Central Zone = 5 Hrs * 60 = 300
-- Eastern Zone = 4 Hrs * 60 = 240
select JSSCHJBNM, JSSCHLNCSTAT, JSSCHSTTIME, dateadd(mi,((JSSCHSTTIME-300)),'1970-01-01 00:00') "DateStartTime" FROM SY900.F91320
where JSSCHJBNM = 'XXXXXXX';
 
Top