Return Time with mysql

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
  • Teqskater
    Forum Member
    • Apr 2007
    • 175

    Return Time with mysql

    Does somebody know how to return the time with a MySQL Query?
    I found this query (CURTIME()) on the internet but i dont know how to use it with the mysql examples that can be found around the forums. i need the time from a server for security reasons. i dont want the time of the pc running my program.
  • Teqskater
    Forum Member
    • Apr 2007
    • 175

    #2
    I found the solution. i use this query for it:
    time = MySQLQueryToTable("SELECT CURRENT_TIME")

    Then time.Data[1].CURRENT_TIME contains the current time.
    for example: 23:12:06

    I hope this may come in handy for someone

    Comment

    • Dermot
      Indigo Rose Customer
      • Apr 2004
      • 1791

      #3
      Thanks.

      ---
      Last edited by Dermot; 01-02-2008, 09:33 AM.
      Dermot

      I am so out of here :yes

      Comment

      Working...
      X