CF_SQL_TIME is for temporal data (times), CF_SQL_DATE is for dates,
and CF_SQL_TIMESTAMP is for timestamps (datetimes).
cheers,
barneyb
On 11/10/05, Casey C Cook <[EMAIL PROTECTED]> wrote:
> Hi -
>
> Does anyone know the difference between CF_SQL_TIME and CF_SQL_TIMESTAMP
> when using cfqueryparam on a table insert? We have a situation where we
> use CF_SQL_TIME and its works fine in one environment, but we migrate to
> another environment and in order to get the insert to work correctly I
> have to use CF_SQL_TIMESTAMP. The coldfusion server version seem to be
> same MX 6.1 except for one is enterprise version and one is not. Im not
> certain about oracle database versions.
>
> Heres the code in question:
> <cfquery name="getTime" datasource=#DataSource#>
> select sysdate now from dual
> </cfquery>
> <cfqueryparam cfsqltype="cf_sql_time" value="#DateAdd('n', 70,
> getTime.now)#">
>
> Thanks,
> CC
> x56927
>
>
> ----------------------------------------------------------------------------------------
> This is a PRIVATE message. If you are not the intended recipient, please
> delete without copying and kindly advise us by e-mail of the mistake in
> delivery. NOTE: Regardless of content, this e-mail shall not operate to
> bind CSC to any order or other contract unless pursuant to explicit
> written agreement or government initiative expressly permitting the use of
> e-mail for such purpose.
> ----------------------------------------------------------------------------------------
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:223901
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
