Timothy,
Not very efficient but you could perhaps convert the string to a proper date
format at run-time and then sort it.
Dave
-Original Message-
From: Timothy Heald [mailto:healdt;dsmail.state.gov]
Sent: 25 October 2002 13:12
To: CF-Talk
Subject: Verity Ordering Take 2.
Hey,
Yeah I think it's going to be good old bubble sort time. Dang.
Thanks,
Tim
-Original Message-
From: Dave Wilson [mailto:dave;autosdirect2u.com]
Sent: Friday, October 25, 2002 8:20 AM
To: CF-Talk
Subject: RE: Verity Ordering Take 2.
Timothy,
Not very efficient but you could perhaps
Quoting Timothy Heald [EMAIL PROTECTED]:
I have 2 Verity indexes I am searching. They both contain a filed
date_created, and I have added this field as custom2 to the search.
I need to be able to sort by date off of that field. Now it is
returning the field as a string right now
, October 25, 2002 8:42 AM
To: CF-Talk
Subject: Re: Verity Ordering Take 2.
Quoting Timothy Heald [EMAIL PROTECTED]:
I have 2 Verity indexes I am searching. They both contain a filed
date_created, and I have added this field as custom2 to the search.
I need to be able to sort by date off
Quoting Timothy Heald [EMAIL PROTECTED]:
I tried query of query, but it treats it as a string, not a date.
If formatted as mmdd that is not a problem. That is exactly why it
is the standard dateformat, you can sort it :)
Jochem
, 2002 9:06 AM
To: CF-Talk
Subject: RE: Verity Ordering Take 2.
Quoting Timothy Heald [EMAIL PROTECTED]:
I tried query of query, but it treats it as a string, not a date.
If formatted as mmdd that is not a problem. That is exactly why it
is the standard dateformat, you can sort it :)
Jochem
Quoting Timothy Heald [EMAIL PROTECTED]:
You are the man, I didn't even think about that. Ok, so is there a
function (like convert() in SQL Server) that would let you change the
date format for the whole column at once?
Don't think so. But where does Verity get that date from, and can't you
To: CF-Talk
Subject: RE: Verity Ordering Take 2.
Quoting Timothy Heald [EMAIL PROTECTED]:
You are the man, I didn't even think about that. Ok, so is there a
function (like convert() in SQL Server) that would let you change the
date format for the whole column at once?
Don't think so
Got it. Use to_char not to_date :)
Tim
-Original Message-
From: Timothy Heald
Sent: Friday, October 25, 2002 10:05 AM
To: CF-Talk
Subject: RE: Verity Ordering Take 2.
I am trying to do that with Oracle's to_date function, but it keeps saying that a char
was found where a numeric
Tim,
If the field is already a date field in Oracle, you don't want to use
to_date, you want to use to_date(to_char()). To_date expects a char field,
so if you want to use it for reformatting a date, you have to to_char the
date, then to_date it.
Deanna Schneider
Interactive Media Developer
[mailto:deanna.schneider;ces.uwex.edu]
Sent: Friday, October 25, 2002 11:41 AM
To: CF-Talk
Subject: Re: Verity Ordering Take 2.
Tim,
If the field is already a date field in Oracle, you don't want to use
to_date, you want to use to_date(to_char()). To_date expects a char field,
so if you want to use
11 matches
Mail list logo