Results 1 to 2 of 2

Thread: current date

  1. #1
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Unanswered: current date

    hi,
    is there any thing like getdate() in mysql ??
    and how can we know the current time format settings of the mysql server and how to change these settings?
    thanks in advance,
    regards,
    harshal.

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320

    Re: current date

    Originally posted by harshal_in
    hi,
    is there any thing like getdate() in mysql ??
    and how can we know the current time format settings of the mysql server and how to change these settings?
    thanks in advance,
    regards,
    harshal.
    You can use CURDATE() to retreive the current date or CURRENT_DATE
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

Posting Permissions

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