CodingForums.com - View Single Post - Storing ColdFusion date object into a relational database?

Gjslick · 04-15-2012, 06:15 PM

When you pass a formatted date/time string into a DATETIME column, SQL Server will automatically convert it to its underlying date format. To use a format that should be able to be read by SQL Server, use the createODBCDateTime() function.

So for example:

Code:

<cfset myDate = now()>

<cfquery datasource="mydsn">
    INSERT INTO myTable ( myDateCol )
    VALUES ( '#createODBCDateTime( myDate )#' )
</cfquery>

For your "auction ending" feature, one way to do it is to create a ColdFusion scheduled task which runs a .cfm page maybe every minute or so. This .cfm page would check the database for expired auctions that haven't yet been processed, and send out the appropriate emails and such. (You could also have some other non-ColdFusion solution for this on your server, but this would probably be easiest.)

04-15-2012, 06:15 PM	PM User \| #2
Gjslick Regular Coder Join Date: Feb 2009 Location: NJ, USA Posts: 476 Thanks: 2 Thanked 70 Times in 69 Posts	When you pass a formatted date/time string into a DATETIME column, SQL Server will automatically convert it to its underlying date format. To use a format that should be able to be read by SQL Server, use the `createODBCDateTime()` function. So for example: Code: <cfset myDate = now()> <cfquery datasource="mydsn"> INSERT INTO myTable ( myDateCol ) VALUES ( '#createODBCDateTime( myDate )#' ) </cfquery> For your "auction ending" feature, one way to do it is to create a ColdFusion scheduled task which runs a .cfm page maybe every minute or so. This .cfm page would check the database for expired auctions that haven't yet been processed, and send out the appropriate emails and such. (You could also have some other non-ColdFusion solution for this on your server, but this would probably be easiest.)