MS SQL Funtion Resources

[bholm]

I'm in need of an online reference to MS SQL Server supported functions I can use in my Cold Fusion queries to an Access 97 db.

I can't get a simple select like the following to be accepted!

SELECT date1, event, locname, city, state
FROM rof_events
WHERE date1 > 2001-04-01

Is lists all entries in the table.
Help! Thanks!

 

[JohnLowell]

Try this:

SELECT date1, event, locname, city, state
FROM rof_events
WHERE date1 > '2001-04-01'

 

[bholm]

I did try that. The server complains of a type conflict. I think it thinks it is a string data type instead of a date type.

This is such a basic question but I can't figure out how they expect you to specify the date and get it to accept it.

 

[bholm]

I just now figured it out... you have to put # symbols around the date....so its
WHERE date1 > #04/01/2001#

Then in Cold Fusion I have to escape those with additional # symbols so it becomes

WHERE date1 > ##04/01/2001##

I'd still like an online reference to the Date type functions that MS supports. Like what if I want just the year in a date? What if I want just the month of a date?
Your help would be appreciated!!