Ask a Question related to Coldfusion Database Access, Design and Development.
-
cwhitmor #1
date format change from YYYYMMDD?
We are in the process of migrating our database server over to a new system.
The old system has Coldfusion 4.5, Win2k Server and MS SQL 2000. We're
migrating to Coldfusion MX7, Win2003 and MS SQL 2000.
Everything seems to work on the new system, but the date that get posted onto
the database are in the format YYYYMMDD instead of MMDDYYYY
Is this something that can be changed on the ColdFusion side or MS SQL?
cwhitmor Guest
-
Format a date
My database stores the date as mm/dd/yyyy How can I return this in the format of say: Tuesday- December 21, 2005 -
Date format change not working
Im trying to change the date format entered into a textbox from dd/mm/yy to yyyy/mm/dd so as my stored procedure is run correclty. The date is... -
Change Date Format
I have a date being entered into a textbox in a dd/mm/yy format, however I need to be able to change this format to a yyyy/mm/dd in order to pass the... -
converting date into database date format(newbie)
Hi! U can convert "8-Aug-03" into mysql date which requires yyyy-mm-dd format as below. <?php date("Y-m-d",strtotime("8-Aug-03")); ?> -
Nautulus: time/date format change ?
I run RH9 with Gnome / Nautilus. I am irritated by the time/date format in Nautilus. like : " Wednesday, July 9 2003 at 10:44:14 PM " ! Does... -
Dan Bracuk #2 Re: date format change from YYYYMMDD?
Did you actually change databases? You mention sql 2000 for both.
In any event, as long as you are storing dates as dates and not text, it never
matters what format you think the database is storing it in. Between the
createodbcdate and dateformat functions you have full control.
Dan Bracuk 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
