Grouper Users - Open Discussion List

[Chris Hyzer <>]

I think it’s the number of millis since 1970.  Why do you need to convert it?  For a view to see what it is?  There should be a way to do that

 

http://stackoverflow.com/questions/14716744/mssql-convert-milliseconds-since-1970-to-datetime2

 

I create views in oracle that convert that column to something more user friendly…

 

If you are setting something in those fields, you should calculate the number of millis since 1970 and put that number in there (not that you should be writing to Grouper registry tables J )

 

Thanks,

Chris

 

From: Omaraie, Brad [mailto:]
Sent: Monday, September 16, 2013 6:57 PM
To: Chris Hyzer
Subject: Created_on converstion

 

Hi Chris,

Quick question regarding the date conversions. I see you guys are using a decimal(19,0) for "created_on" in "grouper_change_log_entry" and "grouper_change_log_entry_temp" tables. We are using SqlServer as our database. I'M not sure how to convert this to datetime or any other sort of timestamp type. I tried the Convert and Cast methods of SqlServer but they both threw overflow exception. How can I do this conversion with tsql commands?

 

Thanks.

Brad