Re: Oracle Date Field

2005-01-25 Thread Larry White
/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

Oracle Date Field

2005-01-25 Thread ColdFusion Developer
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.

RE: Oracle Date Field

2005-01-25 Thread James Holmes
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

RE: Oracle Date Field

2005-01-25 Thread Pascal Peters
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

Re: Oracle Date Field

2005-01-25 Thread ColdFusion Developer
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

RE: Oracle Date Field

2005-01-25 Thread James Holmes
: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

Re: Oracle Date Field

2005-01-25 Thread Ian Winter
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