MS SQL Date Usage Tutorial 1

[bholm]

Does anyone know of a good online source for a summary on how to use dates within MS SQL and Access 97. I'm trying to understand and learn the usage of dates while programming a Cold Fusion template using MS SQL queries to talk to a Access 97 db. MS does things the usual confusing way... Some rules of thumb or online tutorials would be excellent.

Thanks

 

[tlbroadbent]

Try these links.

http://wa.apana.org.au/~abrowne/ser-36.html

http://support.microsoft.com/support/kb/articles/Q88/6/57.ASP

http://msdn.microsoft.com/library/en-us/dnaccgen/html/msdn_datetime.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[bholm]

Thanks so much, Terry!
That helps. What makes it particularly tricky for me working with Cold Fusion is that CF specifies variables with # symbols surrounding them. So to have a date variable in an MS SQL query that uses # symbols makes it hard at times.

Bruce

 

[tlbroadbent]

IYou don't need to use # in T-SQL. You can delimit dates with single quotes (i.e., 'jan 01 2001'). Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.