Formatting Dates in ASP, PHP, MySQL, SQL Server, Cold Fusion, VB, VB.NET and More!

Formatting Dates/Times in ASP, PHP, Cold Fusion, VB.NET Notes

Ever find yourself needing to remember how to format a date or time in a particular programming language? Here is a list of different programming languages and how to format a date or time in that language.

PHP

$current_date=date("m/d/Y"); // returns 09/15/2007
$current_time_military=date("H:i:s"); // returns 18:09:54 time in military
$current_time_ampm=date("h:i:s a"); // returns 06:09:54 pm time in 12 hour format am/pm
$date_time_for_mysql=date("Y-m-d")." ".date("H:i:s"); // returns "2007-09-15 18:09:54".

$olddate="03/21/2004";
$mynewdate=date("Y-m-d", strtotime($olddate)); // Converts a Date Formatted "03/21/2004"
echo($mynewdate); // To New Date Format "2004-03-21" (Used by MySql Date Field)

Use this to format date/time when constructing MySQL Insert/Update Statements

Click here for full list of format options...

Classic ASP

x=now()
current_date_time=month(x) & "/" & day(x) & "/" & year(x) 'returns 9/17/2007
current_time=hour(x) & ":" & minute(x) & ":" & second(x) 'returns 18:14:25 military time

VB.NET/ASP.NET

Dim x
x=Now
current_date=Format(Now, "MM/dd/yyyy") 'Returns 09/15/2007
current_time=Format(Now, "hh:mm:ss tt") 'Returns 10:23:45 PM
current_time_military=Format(Now, "HH:mm:ss")'Returns 22:23:45 in military
current_time_military=FormatDateTime(Now, vbShortTime) 'Returns 22:23 in military

Cold Fusion

<cfset todayDate = Now()>
#DateFormat(todayDate, "mm/dd/yyyy")#   Rem returns 09/16/2008
#TimeFormat(todayDate, "HH:mm:ss")#    Rem returns 21:12:07 military
#TimeFormat(todayDate, "hh:mm:sstt")#   Rem returns 09:12:07 pm

            Click here for full list of date format options... / Click here for full list of time format options...

Enter Feedback/Comment for this Article