RE: Date format in access

[Mike Townend]

afaik Now() is already in this format, so you should be able to write
either...


<CFQ>
    INSERT INTO foo (dtWhatever)
    VALUES (#Now()#)


or
    INSERT INTO foo (dtWhatever)
    VALUES (<CFQUERYPARAM VALUE="#Now()#" CFSQLTYPE="CF_SQL_TIMESTAMP">)
   
or maybe even the inbuild access object (for Now() anyway) which i beleve is

INSERT INTO foo (dtWhatever)
    VALUES (Now)

HTH


-----Original Message-----
From: Dan Farmer [mailto:[EMAIL PROTECTED]
Sent: Monday, December 1, 2003 15:46
To: CF-Talk
Subject: Re: Date format in access

<cfset AccessDate = #CreateODBCDateTime(Now())#>

>Hi
>
>Can someone tell the date format to use in CFQuery in select/insert
>statement for an access DB?
>
>thanks
>
>Shahzad.Butt
>Ph:  +44 (0) 1992 701 722
>Fax: +44 (0) 1992 701 604
>
>
>
  _____

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---