+ Reply to Thread
Results 1 to 2 of 2

Thread: convert INT to datetime

  1. #1
    Junior Member
    Join Date
    Jan 2012
    Posts
    35

    convert INT to datetime

    I have 1323648000 which is int(10). I need to convert date to format >> dd/hh/yy hh:mm:ss.
    Any Ideas ?

  2. #2
    Junior Member
    Join Date
    May 2012
    Posts
    6
    You need to use the unixepoch , that is a standard since 1970 , here is an example :
    Code:
    select datetime( 1323648000, 'unixepoch' );
    That should give for example : 2012-12-12 00:00:00 (GMT)

    Also you can try :
    Code:
    TO_CHAR(column_name, 'DD/MM/YYYY hh:mm:ss')
    I am not sure about this , i just found it over the internet , but may help too.

+ Reply to Thread

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts