ATK Solutions Inc.
Online Portfolio Our Products Software Design Website Design Website Promotion Ecommerce Stores Mobile Applications Online Articles Fun Flash Games Contact Us

ATK Solutions Inc.

Online Portfolio Our Products Software Design Website Design Website Promotion Ecommerce Stores Mobile Applications Online Articles Fun Flash Games Contact Us
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

#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

Share: 
 
Enter Feedback/Comment for this Article  /  Contact Us


Home / Software Development / Website Design / Bookmark Page / Privacy Policy

Copyright © ATK Solutions, Inc. All Rights Reserved