MSSQL - Convert UNIX time
Hello,
We are running SD6+ with MSSQL 2003 as the DB.
I am creating a new custom query to pull assets and who they are loaned to incluiding start and end dates, but have encountered and issue with the dates being stored in UNIX time and MSSQL not having any inbuilt methods of translatting UNIX Time to human readable time.
I am after a way for me to be able to write a query that will convert the time from UNIX time to human readable time.
Thanks,
Matt
We are running SD6+ with MSSQL 2003 as the DB.
I am creating a new custom query to pull assets and who they are loaned to incluiding start and end dates, but have encountered and issue with the dates being stored in UNIX time and MSSQL not having any inbuilt methods of translatting UNIX Time to human readable time.
I am after a way for me to be able to write a query that will convert the time from UNIX time to human readable time.
Thanks,
Matt