RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread S . Isaac Dealey
ead of a datetime > and I always had the > problem of people putting in things like INC or NR or > other stuff where the > date needed to go. > Steve > -Original Message- > From: Eric Creese [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 01, 2003 2:59 PM > To:

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread DURETTE, STEVEN J (AIT)
ginal Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 2:59 PM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION the date string in the 255 varchar field is stored as Jul 01 2003 12:00 AM now if I put the " convert(datetime,substring(demographicvalu

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Eric Creese
- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 1:38 PM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION Without seeing the actual data being converted, my guess would be that substring 11 is the problem. IE: 06/30/2003 = 10 characters not 11. Also,

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Matthew Small
o: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION Ok, I need a sanity check! Isn't 06/30/2003 only 10 characters? Just wondering because after my initial post I see a lot of replies with the 11 back in there? Steve -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread DURETTE, STEVEN J (AIT)
-Talk Subject: RE: SQL DATE CONVERSION QUESTION Oh, ok, you've got an error meaning that some of the data that you are converting actually is not date information. Maybe you could do this: Where ... And isdate(substring(demographicvaluedesc,1,11)) is true Matthew Small IT Director Showstoppe

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Matthew Small
ECTED] 843-357-1847 -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 2:57 PM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION Yes I tried this, same error. -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Tu

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Matthew Small
ECTED] 843-357-1847 -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 2:57 PM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION Yes I tried this, same error. -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Tu

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Eric Creese
Yes I tried this, same error. -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 1:46 PM To: CF-Talk Subject: Re: SQL DATE CONVERSION QUESTION Have you tried using Cast instead of Convert, ie My query: select personid from persondemographic

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Matthew Small
[mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 2:06 PM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION No SQL Gurus out there? -Original Message- From: Eric Creese Sent: Tuesday, July 01, 2003 7:49 AM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION Can anyone see

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Matthew Small
[mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 2:06 PM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION No SQL Gurus out there? -Original Message- From: Eric Creese Sent: Tuesday, July 01, 2003 7:49 AM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION Can anyone see

Re: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Marlon Moyer
Creese wrote: >No SQL Gurus out there? > >-Original Message- >From: Eric Creese >Sent: Tuesday, July 01, 2003 7:49 AM >To: CF-Talk >Subject: RE: SQL DATE CONVERSION QUESTION > > >Can anyone see what I am doing wrong? If I use the convert statement in the sel

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread DURETTE, STEVEN J (AIT)
about all that I can tell you. Steve -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 2:06 PM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION No SQL Gurus out there? -Original Message- From: Eric Creese Sent: Tuesday, July 01

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Eric Creese
No SQL Gurus out there? -Original Message- From: Eric Creese Sent: Tuesday, July 01, 2003 7:49 AM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION Can anyone see what I am doing wrong? If I use the convert statement in the select clause instead of the where clause it works but I

RE: SQL DATE CONVERSION QUESTION

2003-07-01 Thread Eric Creese
: SQL DATE CONVERSION QUESTION I am trying to query on a field that is a varchar(255) but has date information. I get the following error: Server: Msg 241, Level 16, State 1, Line 1 Syntax error converting datetime from character string. My query: select personid from persondemographic where

SQL DATE CONVERSION QUESTION

2003-06-30 Thread Eric Creese
I am trying to query on a field that is a varchar(255) but has date information. I get the following error: Server: Msg 241, Level 16, State 1, Line 1 Syntax error converting datetime from character string. My query: select personid from persondemographic where convert(datetime,substring(demog