Results 1 to 3 of 3

Thread: SQL dateFormat

  1. #1

    SQL dateFormat

    Hey guys,
    Is there a way when you are doing a SQL insert to modify the date? For example I want this, dateFormat(now(),"MM/DD/YYYY"), but instead of now I want Tomorrow. SO basically it will add one day to the date.

  2. #2
    Join Date
    Jan 2003
    There should be a dateAdd fuction you can use. What SQL server is this, MS SQL?
    Game Servers are the next hot market!
    Slim margins, heavy support, fickle customers, and moronic suppliers!
    Start your own today!

  3. #3
    <cfquery datasource="#datasource" name="checkout">
    Insert into checkout (
    stufacid )
    VALUES ('#dateformat(now(),"mm/dd/yyyy")#',
    ('#dateformat(now(),"mm/dd/yyyy")#', <--- I want this to be plus 1 for the date

Posting Permissions

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