RE: SQL Convert and joining on date

2001-02-14 Thread Duane Boudreau
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,

RE: SQL Convert and joining on date

2001-02-14 Thread Seva Petrov
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]]

RE: SQL Convert and joining on date

2001-02-14 Thread Duane Boudreau
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