get current time

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sejal17
    New Member
    • Dec 2007
    • 56

    get current time

    hi,
    I want to insert the current time in my database.how can i get the current time?

    thanks in advance.
  • harshmaul
    Recognized Expert Contributor
    • Jul 2007
    • 490

    #2
    if the database is Mysql u can use

    Code:
    NOW
    which is a mysql reserved word
    and heres a link with more info...



    If your not using MySql... WHY NOT, nah just kidding...
    if no MySQL then...



    hope that helped.

    Comment

    • Amzul
      New Member
      • Oct 2007
      • 130

      #3
      Originally posted by harshmaul
      if the database is Mysql u can use

      Code:
      NOW
      NOW()
      with '()' for function

      Comment

      • harshmaul
        Recognized Expert Contributor
        • Jul 2007
        • 490

        #4
        oops. (*tying a noose for an internet suicide)

        Comment

        Working...