SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Sep 2010
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Current Time Stamp Change

    Hi,

    Need your help regarding this. I would like to change the current date ( now() ) of my MySQL. I tried:

    SET TIMESTAMP=unix_timestamp('2010-10-01 12:34:56');

    but it does not work. Please need your help.

    Thank you.

  2. #2
    SitePoint Evangelist
    Join Date
    Jun 2007
    Location
    North Yorkshire, UK
    Posts
    483
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It is my understand that now() is the current time of the computer on which mysql is running so the solution would be to change the time of he computer.

    Timestamp is a data type.

    Edit.................

    Sorry, should have looked at the documentation first, you are right timestamp is a variable that can be set.


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
  •