RE: [KCFusion] Date Query
Thanks, that was exactly what i needed. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bakken, Kory Sent: Tuesday, March 19, 2002 9:39 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Date Query You have to change the date into a date that SQL can use in compare statements like such... ... WHERE inspDate > #CompareDate# -Original Message- From: James K Tieman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 9:04 AM To: KCFusion Subject: [KCFusion] Date Query How do I do write this where clause to a Date/Time field in Access2000? WHERE inspDate > 01/31/2002 Jamie __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Date Query
You have to change the date into a date that SQL can use in compare statements like such... ... WHERE inspDate > #CompareDate# -Original Message- From: James K Tieman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 9:04 AM To: KCFusion Subject: [KCFusion] Date Query How do I do write this where clause to a Date/Time field in Access2000? WHERE inspDate > 01/31/2002 Jamie __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Date
Look at Oracle's TO_CHAR() and TO_DATE() functions. Thanks, Robin Greenhagen President GreenSoft Solutions, Inc. http://www.greensoft.com/ > -Original Message- > From: Smith, Jim [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 17, 2001 9:55 AM > To: KCFusion > Subject: [KCFusion] Date > > > How do I format a date to insert into an oracle table when I > want to have > the date/time as mmddhhmiam? I keep getting format errors. > > > __ > The KCFusion.org list and website is hosted by Humankind Systems, Inc. > List Archives http://www.mail-archive.com/cf-list@kcfusion.org > Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] > To Subscribe mailto:[EMAIL PROTECTED] > To Unsubscribe mailto:[EMAIL PROTECTED] > > __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Date Formats
DateFormat functions in CF. If you are using doing any International display, use LSDateFormat. Cheers! Robin Greenhagen President/CEO GreenSoft Solutions, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 4:03 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Date Formats How would you all recommend that I deal with the output of a date field? I have a SQL database with a date field of type smalldatetime. However, when I output the value using CF, it looks like this: 2000-01-01 00:00:00. Is there an easy way to tell CF to format it like this without using JavaScript: 01/01/2001? Thank you all so much!! Jered __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] Date Formats
Try #dateformat(datefield, "mm/dd/")# Robin Krause Webmaster Central Missouri State University Conference Center 556 660.543.8487 >>> [EMAIL PROTECTED] 06/11/01 04:03PM >>> How would you all recommend that I deal with the output of a date field? I have a SQL database with a date field of type smalldatetime. However, when I output the value using CF, it looks like this: 2000-01-01 00:00:00. Is there an easy way to tell CF to format it like this without using JavaScript: 01/01/2001? Thank you all so much!! Jered __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]