# SQL time/date format - quick question

**URL:** <https://forum.kirupa.com/t/sql-time-date-format-quick-question/221109>\
**Category:** programming\
**Created:** [April 1, 2007, 3:21pm UTC](https://forum.kirupa.com/t/sql-time-date-format-quick-question/221109 "2007-04-01T15:21:48Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mr\_Paul\_Jones](https://avatars.discourse-cdn.com/v4/letter/m/22d042/32.png) [@Mr\_Paul\_Jones](https://forum.kirupa.com/u/Mr_Paul_Jones)\
**Post date:** [April 1, 2007, 3:21pm UTC](https://forum.kirupa.com/t/sql-time-date-format-quick-question/221109/1 "2007-04-01T15:21:48Z")

</div>

When time/date is recorded as a long number, how do I convert it into an understandable time/date? Im guessing there is a calculator that I can use or something?

Like this for example is a session login time for a forum - 1175190266  
But that means nothing to me

thanks