asked on
Date Time in Coldfusion
I have this in the my code
<cfset curDate = #Now()#>
<cfinvokeargument name="actiondttm" value=#curDate#/>
it saves the Date but not the time .. How do I get current Date/time stamp ??
<cfset curDate = #Now()#>
<cfinvokeargument name="actiondttm" value=#curDate#/>
it saves the Date but not the time .. How do I get current Date/time stamp ??
Web Development Software
Last Comment
skb73
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
if you are saving to a database, try using createODBCDateTime( function
most databases have a date function built in, so if you just want to put the current date/time into the database, the easiest way is just do it in the datatbase's language.
For example, if you're using SQL Server just say
update mytable
set theDateColumn = getDate()
where .... ^^^^ gives the date and time
If you need to do it in coldfusion for some reason do it like this..
update mytable
set theDateColumn = #createODBCdateTime(now())
or if using a function parameter...
update mytable
set theDateColumn = #createODBCdateTime(argume
ASKER
My bad ! Now() did it and I useed CF_SQLTYPE_TIMESTAMP to save it as date/time