Hi All, Thanks a lot for the answers. It works now...
Thanks > Using cfsqltype="cf_sql_timestamp" will definitely solve that problem. > > > I expect you're just trying to give an example, but if all you're > trying to do is move values from one table to another, you can do > this > en-mass with SQL: > > <cfquery name="putdate" datasource="whatever"> > insert into table2(date_field2) > select date_field1 from table1 > </cfquery> > > Cheers, > Kris > > > > I have an issue inserting date and time together into a database > table from coldfusion. > > > > Right now, I am using <cfquery> to get records from a particular > table, in which one of the field is date, and its value in the > database is something like > > "2/14/2007 9:10:12 AM". I am performing insert operation into > another table which has to insert this date field into the column of > new table. I am doing currently as follow: > > > > <cfquery name="getDate" datasource="" maxrows="1"> > > select date_field from table > > </cfquery> > > > > <cfif getDate.recordcount is not 0> > > <cfquery name="insertDate" datasource=""> > > insert into table2 (date_field1) values (<cfqueryparam > cfsqltype="cf_sql_date" value=#getDate.date_field#>) > > </cfquery> > > </cfif> > > > > The problem with this is only the date is getting inserted but not > the time. How to format ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322437 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4