can I strongly recomment "cleaning" that data (and converting to ODBC dateTime) just after the view and well before it gets anywhere near the model (reactor)?
On 7/28/06, Dan Vega <[EMAIL PROTECTED]> wrote:
This is totally off toopic but I can not solve this one. I need to compare an odbc datetime to a users input date so here is the comparision 2006-07-25 17:08:41.147 compare to 07/25/2006 I have been looking at various sql functions conver,cast,date extration methods but just can not figure out a clean way to do this. If there was not time I ould usually use createODBCDate() against the users input but i wont know the time at the time i need to convert it. Sorry to bother everyone. Thanks -- Dan Vega [EMAIL PROTECTED] -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
