Ask a Question related to Coldfusion Database Access, Design and Development.
-
paross1 #1
Re: Inserting both date AND time into one timestampcolumn
Function parsedatetime() will allow you to return a datetime object by
combining a date and time string:
<cfset dte="jan 22, 2005">
<cfset tim="2:23:00pm">
<cfoutput>#parsedatetime(dte&tim)# </cfoutput>
Output:
{ts '2005-01-22 14:23:00'}
Phil
paross1 Guest
-
Inserting both date AND time into one timestamp column
Probably something really easy that i'm missing here.... I have a form with both a date field and a time field for a users sessions info. User... -
Inserting an automatic date?
I notice that when I want to insert a date, it only resets once the page has been updated. But I found a few pages on my site that has an... -
CFMX7.0.1 Administrator date time issue showing 13hrsbehind server time
I am running a W2k SP4 box that has been upgraded from CFMX6 to CFMX7.0.1. The CFMX7.0.1 server is showing the date on the Server Settings >... -
Convert date/time to date in SQL Server 2000 statement
Can this be done? tia -
inserting date
Use the Date function. In your query, it would be something like SELECT Field1, Field2, Date() FROM MyTable For the text box, you'd set its... -
orionMX #2 Re: Inserting both date AND time into one timestampcolumn
THANK YOU!!!
Not sure how i missed that one....
Frank
maybe next time i wont be such a dumbass
orionMX Guest
-
The ScareCrow #3 Re: Inserting both date AND time into one timestampcolumn
Not sure you need to parse this at all, why not just
CreateODBCDateTime(#form.date# #form.time#) -- note space between values.
This should then create the correct odbcdatetime object.
Ken
The ScareCrow Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
