Results 1 to 2 of 2

Thread: Format Date

  1. #1
    Join Date
    Aug 2004
    Posts
    77

    Unanswered: Format Date

    I want to insert today's date into database. The date format must be something like this 02 September 2004

    How can I write sql ? I tried
    dim d
    d=formatDateTime(Date,1)
    sql="insert into datagraph(dat ) values('"&d&"')"

    But the result is Thursday, September 02,2004. It doesn't what I want.
    I want 02 September 2004 .

    I am so so .....tired with sql !! :-(

  2. #2
    Join Date
    Aug 2004
    Posts
    330
    You may want to pose this question in the forum for your specific DBMS, so that the date format can be addressed for that system.

Posting Permissions

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