Got it, a little more digging did the trick.
CONVERT(char(12), t1.date1, 107) = CONVERT(char(12), t2.date2, 107)
-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 1:17 PM
To: CFTalk
Subject: SQL Convert and joining on date
Hi All,
Duane,
Assuming you use SQL Server, you could do the following:
convert(varchar(10), t1.datefield, 110)
That should produce a result in the "mm-dd-" format.
Best,
Seva Petrov
Senior Developer
TheSquare.com
-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
On a slightly different topic, is there a way to do a custom defined
formatting mask?
Duane
-Original Message-
From: Seva Petrov [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 3:01 PM
To: CF-Talk
Subject: RE: SQL Convert and joining on date
Duane,
Assuming you use SQL
3 matches
Mail list logo