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:
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
-
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,
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
-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
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
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
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
[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
[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
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
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
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
: 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
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
15 matches
Mail list logo