Thursday, February 09, 2012

Calendar

<< Sep 2000 >>

S	M	T	W	T	F	S
					1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28	29	30

Categories

• Acrobat (5) [RSS]
• Adobe (110) [RSS]
• AdobeMAX06 (45) [RSS]
• AdobeMAX07 (59) [RSS]
• AdobeMAX08 (66) [RSS]
• AdobeMAX09 (39) [RSS]
• AdobeMAX10 (34) [RSS]
• AdobeMAX11 (27) [RSS]
• AIR (297) [RSS]
• Appearances (217) [RSS]
• Books (86) [RSS]
• CFEclipse (15) [RSS]
• Cloud (1) [RSS]
• ColdFusion (1477) [RSS]
• ColdFusion Builder (22) [RSS]
• Data Services (42) [RSS]
• Fish Tank (5) [RSS]
• Flash (356) [RSS]
• Flex (562) [RSS]
• Home Automation (5) [RSS]
• HTML5 (23) [RSS]
• JavaScript (2) [RSS]
• Jobs (130) [RSS]
• jQuery (14) [RSS]
• JRun (14) [RSS]
• Labs (62) [RSS]
• LiveCycle (37) [RSS]
• MAX (284) [RSS]
• Mobile (239) [RSS]
• Regular Expressions (19) [RSS]
• RIA (21) [RSS]
• SQL (45) [RSS]
• Stuff (554) [RSS]
• Tips (CF Studio) (80) [RSS]
• Tips (CF) (795) [RSS]
• Tips (Dreamweaver) (91) [RSS]
• Tips (Flex Builder) (2) [RSS]
• Using CF (167) [RSS]

Other BLOGs

• Charlie Arehart
• Lee Brimelow
• Ray Camden
• Christophe Coenraets
• Sean Corfield
• Mihai Corlan
• Cornel Creanga
• Mark Doherty
• John Dowdell
• Danny Dura
• Enrique Duvos
• Steven Erat
• Kevin Hoyt
• Serge Jespers
• Adam Lehman
• Duane Nickull
• Miti Pricope
• Andrew Shorten
• Ryan Stewart
• James Ward
• Greg Wilson
• Full As A Goog

RSS Feeds

• Feed
• Subscribe

Join my mailing list and find out about new books and other topics of interest.

Thoughts, ideas, tips, musings, and pontifications (not necessarily in that order) by Ben Forta ...
NOTE: This is my personal blog, and the opinions and statements voiced here are my own.

Viewing By Day : September 15, 2000 / Main

September 15, 2000

Using Dates in SQL Statements

Posted At : 12:00 AM
Related Categories: Tips (CF) :

Any time you pass a date to a SQL statement (using ODBC drivers) use the CreateODBCDate() function to format it correctly. This applies not just to the WHERE clause, but to any part of the SQL statement. Be it the VALUES in an INSERT, the SET in an UPDATE, HAVING, or any other clause, use this function eliminate data conversion problems. (Applies to: ColdFusion All)

Comments (0) | Print |

Comments

There are no comments for this entry.

[Add Comment]