DateTime From ASP to SQL Server

[scohan]

I've got a session variable containing a datetime value populated via 'now'. I need to query a SQL Server 7 table using the datetime value in the where clause. How do I convert the Session value (e.g., '1/22/01 12:51:18 PM') into a datetime format I can use in my SQL select statement? Thanks.

 

[rhyswilliams]

i would use the format() function. E.g. format(DATEVAR,"mm/dd/yyyy&quot (where DATEVAR is your session variable).
hope this helps...

 

[scohan]

When using format, I get:

I get an Microsoft VBScript runtime error '800a01f4'

Variable is undefined: 'format'

/stgpr/asp/tmp.asp, line 24

What am I missing?

Also, do you happen to know the time format I can append to the date format (e.g., ,"mm/dd/yyyy hh:mi:ss"?)