Re: Oracle Date Field
You can use CreateODBCDate() functions to pass dates to Oracle. Oracle says CreateODBCDateTime() formats are supported too, but on some jdbc drivers it chokes. http://www.macromedia.com/devnet/server_archive/articles/cf_best_practices_o racle.html http://www.macromedia.com/devnet/server_archive/articles/cfqueryparam_oracle _databases.html -Original Message- From: ColdFusion Developer [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 January 2005 6:54 To: CF-Talk Subject: Re: Oracle Date Field Thanks, like I said, been a long time since I used it. By chance any website you may have I can reference for more questions like this? Thanks again! James Holmes wrote: ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191718 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Oracle Date Field
INSERT / UPDATE with to_date() SELECT with to_char() -Original Message- From: ColdFusion Developer [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 January 2005 6:48 To: CF-Talk Subject: Oracle Date Field Using a CF Query to add a record to Oracle, I havea date field to add When adding it, it is straightforward, right? When retrieving the date information, I need to do a To_Date function? Is that correct? Been a long time since I had to use Oracle. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191668 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Oracle Date Field
TO_DATE is to add it (you also use it with the cfqueryparam and the cf_sql_type for datetime) TO_CHAR is to retrieve it in the format you want. -Original Message- From: ColdFusion Developer [mailto:[EMAIL PROTECTED] Sent: 25 January 2005 11:48 To: CF-Talk Subject: Oracle Date Field Using a CF Query to add a record to Oracle, I havea date field to add When adding it, it is straightforward, right? When retrieving the date information, I need to do a To_Date function? Is that correct? Been a long time since I had to use Oracle. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191669 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Oracle Date Field
Thanks, like I said, been a long time since I used it. By chance any website you may have I can reference for more questions like this? Thanks again! James Holmes wrote: INSERT / UPDATE with to_date() SELECT with to_char() -Original Message- From: ColdFusion Developer [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 January 2005 6:48 To: CF-Talk Subject: Oracle Date Field Using a CF Query to add a record to Oracle, I havea date field to add When adding it, it is straightforward, right? When retrieving the date information, I need to do a To_Date function? Is that correct? Been a long time since I had to use Oracle. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191670 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Oracle Date Field
http://www.macromedia.com/devnet/server_archive/articles/cf_best_practices_o racle.html http://www.macromedia.com/devnet/server_archive/articles/cfqueryparam_oracle _databases.html -Original Message- From: ColdFusion Developer [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 January 2005 6:54 To: CF-Talk Subject: Re: Oracle Date Field Thanks, like I said, been a long time since I used it. By chance any website you may have I can reference for more questions like this? Thanks again! James Holmes wrote: INSERT / UPDATE with to_date() SELECT with to_char() -Original Message- From: ColdFusion Developer [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 January 2005 6:48 To: CF-Talk Subject: Oracle Date Field Using a CF Query to add a record to Oracle, I havea date field to add When adding it, it is straightforward, right? When retrieving the date information, I need to do a To_Date function? Is that correct? Been a long time since I had to use Oracle. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191672 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Oracle Date Field
The ORACLE docs site may help, the index you're after in this case is: http://www.oracle.com/pls/db92/db92.sql_keywords?letter=Tcategory=#index-TO ps assuming you're using 9i that is, the 8i 10g docs are also there of course. On Tue, 25 Jan 2005 05:54:13 -0500, ColdFusion Developer [EMAIL PROTECTED] wrote: Thanks, like I said, been a long time since I used it. By chance any website you may have I can reference for more questions like this? Thanks again! James Holmes wrote: INSERT / UPDATE with to_date() SELECT with to_char() -Original Message- From: ColdFusion Developer [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 January 2005 6:48 To: CF-Talk Subject: Oracle Date Field Using a CF Query to add a record to Oracle, I havea date field to add When adding it, it is straightforward, right? When retrieving the date information, I need to do a To_Date function? Is that correct? Been a long time since I had to use Oracle. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191673 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54