Results 1 to 1 of 1
  1. #1
    Join Date
    May 2014
    Posts
    5

    Unanswered: [SOLVED] Datetime to posixct

    Date_Time
    07/02/2013 1:00:00 PM

    SELECT weatherhawk.Date_Time
    FROM hol.weatherhawk weatherhawk

    How do i turn into posixct?

    I used this With no Luck

    SELECT UNIX_TIMESTAMP(STR_TO_DATE(Date_Time, '%m %d %Y'))
    FROM hol.weatherhawk weatherhawk


    UPDATE:

    I found this :-)

    update table
    set table.column = UNIX_TIMESTAMP(datetime)



    Nicolai
    Last edited by vestlink; 05-20-14 at 04:35. Reason: [SOLVED] Solution found

Posting Permissions

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