/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
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.
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
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
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
: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
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
7 matches
Mail list logo