SQLTeam.com | Weblogs | Forums

Need help - converting to date time


#1

Trying to figure out how to convert these date time, looks like it is in seconds but trying to figure out the start date is the difficulty. Coming from mosaiq database 6246593
6248191
2805046
2805821
3005202
3005874
3006491
3007046
3009118
3026782
3027547
3135393
3136410
3139961
3254597
3255841
3387863
3389935
3391197
3392579


#2

It could be anything - seconds, or minutes, or some other method they have used to represent dates. I am not familair with Mosaiq database, so I am not able to comment on what it might be. I checked to see if it is epoch time and my guess is that it is not.

Are you able to consult any business users of the software/database to get an idea of what those dates should be? At least a rough idea?


#3

If you know what the actual Date & Time a handful of those numbers represents Some Bright Spark :slight_smile: here will probably be able to work it out for you