[PHP] Formatting Dates in Form before submit
Can anyone tell me how to use the strtotime function within the on change event of a text box?? I need to format the date before submit the form because once it submits it dynamically creates a SQL statement. Is it best to use vbscript or Jscript and if so how? Thanks in advance. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Formatting Dates
Hello, How can I format a date stored in the database in a Date field. It's in this format: -mm-dd I understand that date() function only works for current system date/time. I am looking for something like this: dateformat($date, "mask"), sort of like the one in ColdFusion. Thanks much! stas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Formatting Dates
You could use the mySQL function DATE_FORMAT() in your query string.. SELECT DATE_FORMAT( DateAdded, '%m/%d/%Y' ) as d_Added FROM myDB At 12:52 PM 1/8/01 -0500, stas wrote: Hello, How can I format a date stored in the database in a Date field. It's in this format: -mm-dd I understand that date() function only works for current system date/time. I am looking for something like this: dateformat($date, "mask"), sort of like the one in ColdFusion. Thanks much! stas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]