Art,
You could create a new field "Comb_Date" timedate() data type, and write a
utility to take the three separate fields and combined them into one and
insert it into the Comb_Date field.
Dan
-Original Message-
From: Art Broussard [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Monday, May 15, 2000 10:43 AM
Subject: help converting varchar to number
I am rewriting a site that cant lose any of the information in the tables.
At one point some one made three fields for the date named Month, Day, and
Year. When they did this they set the fields to VARCHAR(40) instead of
number.?! :-/
Now when I do an order by month day year it tries to alphabetize:
1/12/99
11/14/99
2/10/99
instead of ordering numerically.
1/12/99
2/10/99
11/14/99
Any one have an idea on how to deal wiht this? I was told the field would
have to be empty to change from varchar to number in Oracle.
Thanks
Art
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
---
---
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
