What's the easiest way to convert the following date format since the
DateFormat function doesn't like it?
FROM:20010103
TO:01/03/2001
Thanks,
Dave
===
David R Hannum
Ohio University
Web Analyst/Programmer
(740) 597-2524
[EMAIL PROTECTED]
Hello,
Anybody have an idea of how I could convert a text field like "Tue, 18 Feb
2003 14:43:07 -0800" to a format that could be stored as a date field in an
Access 2000 database table formatted like "5/15/2003 5:50:00 PM"?
Thanks,
Craig Hadley
Madison WI
[Todays Threads]
[This Message]
[Su
--- Original Message -
From: "Dave Hannum" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 12:32 PM
Subject: Date Conversion
> What's the easiest way to convert the following date format since the
> DateFormat function do
Try this:
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 11:33 AM
To: CF-Talk
Subject: Date Conversion
What's the easiest way to conver
My Bad, This one works:
#NewDate#
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 11:33 AM
To: CF-Talk
Subject: Date Conversion
What's the ea
Thursday, March 22, 2001 12:33 PM
To: CF-Talk
Subject: Date Conversion
What's the easiest way to convert the following date format since the
DateFormat function doesn't like it?
FROM:20010103
TO:01/03/2001
Thanks,
Dave
===
David R Hannu
t;
Sent: Thursday, March 22, 2001 10:32 AM
Subject: Date Conversion
> What's the easiest way to convert the following date format since the
> DateFormat function doesn't like it?
>
> FROM:20010103
> TO:01/03/2001
>
> Thanks,
> Dave
>
>
" <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 12:52 PM
Subject: Re: Date Conversion
>
>
> #DateFormat(DateNow,"mm/dd/")#
>
> Jay Patton
> Web Design / Application Design
> Web Pro USA
> 406.549.3337 ext. 203
> 1.888.5WEBPRO
> ww
Hey, Regular Expressions are much more fun!!:
Enjoy!!
Lee (Bjork) Borkman
http://bjork.net ColdFusion Tags by Bjork
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or u
Doesn't the date field in Access take a standard odbc date time? (If I'm
wrong let me know, been a long time since I stepped down to Access)
#createodbcdatetime(variables.date)#
Cutter
Craig Hadley wrote:
> Hello,
>
> Anybody have an idea of how I could convert a text field like "Tue, 18 Feb
>
#ParseDateTime('Tue, 18 Feb 2003 14:43:07 -0800')#
--Josh
---
Exciteworkss -- expert hostiong for less!
http://exciteworks.com
Reseller accounts available
Quoting Craig Hadley <[EMAIL PROTECTED]>:
> Hello,
>
> Anybody have an idea of how I could convert a text field like "Tue, 18 Feb
> 2003 14
#ParseDateTime('Tue, 18 Feb 2003 14:43:07 -0800')#
--Josh
---
Exciteworkss -- expert hosting for less!
http://exciteworks.com
Reseller accounts available
Quoting Craig Hadley <[EMAIL PROTECTED]>:
> Hello,
>
> Anybody have an idea of how I could convert a text field like "Tue, 18 Feb
> 2003 14:
hi, i have a field saved in mysql database as a Date type
oddly when i run a cfquery to get it out of the database it comes back with the
following:
{ts '2001-01-01 00:00:00'}
i am assuming ts means timestamp but this seems odd as it is saved as a date
type and if i run the query in the mysql d
Sorry, that should (of course) be:
-Original Message-
From: BORKMAN Lee
Hey, Regular Expressions are much more fun!!:
Enjoy!!
Lee (Bjork) Borkman
http://bjork.net ColdFusion Tags by Bjork
IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used b
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
Any pointers here. I have a varchar field that holds a date value. I need to pull records where the date has yet to expire.
If I run this query, it runs fine.
SELECT * FROM Persondemographic
WHERE DemographicGroupId = 8
AND DemographicItemId = 4
AND convert (datetime,demographicvaluedesc)> getda
That's an ODBC Date.
Just use dateFormat() to make it look however you want.
> -Original Message-
> From: Richard White [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 25, 2006 11:48 AM
> To: CF-Talk
> Subject: cf date conversion
>
> hi, i have a field sa
thanks very much it works fine now :)
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionaut
DateFormat(datevar, '-mm-dd') would output 2001-01-01 just as in the
mysql database. I think date in mysql is date/time. Instead of
'-mm-dd' there are names like 'short', 'medium', 'long' and 'full'
but I don't remember off the top of my head what they output. I think
you would want
ober 25, 2006
-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 25, 2006 10:48 AM
To: CF-Talk
Subject: cf date conversion
hi, i have a field saved in mysql database as a Date type
oddly when i run a cfquery to get it out of the database it comes
: 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
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
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
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
[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
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
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
-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
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
-
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,
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
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:
My cold fusion forum software (using msAccess) has finally buckled under the
heavy loads...
I need to convert my existing msAccess data to another forum package that
uses mySQL.
I am able to convert all existing data except for any DATE field.
All dates in the msAccess db are stored as Date/Time.
It looks like the value in the field isn't a valid "date"
Are any of the entries NULL? That can cause problems too for conversions
like this
> -Original Message-
> From: Eric Creese [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 12, 2003 10:17 AM
> To:
: RE: SQL date conversion issue
It looks like the value in the field isn't a valid "date"
Are any of the entries NULL? That can cause problems too for conversions
like this
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
> To: CF-Talk
> Subject: RE: SQL date conversion issue
>
>
> There are no NULL values but I think the problem may be the
> fact that I have the dates stored in the table two different ways.
>
> Jan 31 1996 12:00AM
> and
> 1/31/1996
>
> -Original Message-
&
How would suggest using it in this case (parson the pun)?
-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Friday, December 12, 2003 9:58 AM
To: CF-Talk
Subject: RE: SQL date conversion issue
Try using CASE to choose which type of conversion you want then
You can
r PM)" conversion, otherwise use
"mm/dd/yy"
A complete list of the codes are here
http://msdn.microsoft.com/library/default.asp?url="">
/ts_ca-co_2f3o.asp
HTH
> -Original Message-
> From: Eric Creese [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 1
I gotcha now. good idea. thanks I will give it a try
-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Friday, December 12, 2003 11:35 AM
To: CF-Talk
Subject: RE: SQL date conversion issue
WHERE CASE RIGHT(demographicvaluedesc, 1) WHEN 'M' THEN
conver
uedesc,101)
END > getdate()
AND DemographicGroupId = 8
AND DemographicItemId = 4
ORDER BY demographicvaluedesc
-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Friday, December 12, 2003 11:35 AM
To: CF-Talk
Subject: RE: SQL date conversion issue
WHE
Check all of your entries - something is going wrong
One of the entries has a "date" that it just can't convert
> -Original Message-
> From: Eric Creese [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 12, 2003 1:05 PM
> To: CF-Talk
> Subject: RE: SQL da
Hi,
I was wondering if anyone can help me out. I am trying to write a query that
will format a date to the following format: March 03, 2005
I know I can use CF's dateformat function but I would prefer to have the query
do this. I know how to do in in Oracle but I cannot get it to work in SQL
x27;s not very pretty, but it works. ;^)
M!ke
-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 03, 2005 3:01 PM
To: CF-Talk
Subject: OT: Date Conversion in SQL.
Hi,
I was wondering if anyone can help me out. I am trying to write a query
that
: Wednesday, August 27, 2003 8:14 PM
To: CF-Talk
Subject: DATE conversion msAccess to mySQL
My cold fusion forum software (using msAccess) has finally buckled under
the
heavy loads...
I need to convert my existing msAccess data to another forum package
that
uses mySQL.
I am able to convert all
: RE: DATE conversion msAccess to mySQL
ahhh, tis quite simple my friend.
that number represents the amount of seconds since jan 1, 1970.
or to go back the other way...
i may have the parameters a bit effed up, but you should get the
picture.
hth
tony
-Original Message-
From: B.H
On Thu, 3 Mar 2005 21:00:37 -, Ciliotta, Mario
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> I was wondering if anyone can help me out. I am trying to write a query that
> will format a date to the following format: March 03, 2005
>
> I know I can use CF's dateformat function but I would prefer to h
48 matches
Mail list logo