| Microsoft®
Visual Basic® Scripting Edition FormatDateTime Function |
| Language Reference |
|
Returns an expression formatted as a date or time.
FormatDateTime(Date[,NamedFormat])The FormatDateTime function syntax has these parts:
Part Description Date Required. Date expression to be formatted. NamedFormat Optional. Numeric value that indicates the date/time format used. If omitted, vbGeneralDate is used.
The NamedFormat argument has the following settings:
Constant Value Description vbGeneralDate 0 Display a date and/or time. If there is a date part, display it as a short date. If there is a time part, display it as a long time. If present, both parts are displayed. vbLongDate 1 Display a date using the long date format specified in your computer's regional settings. vbShortDate 2 Display a date using the short date format specified in your computer's regional settings. vbLongTime 3 Display a time using the time format specified in your computer's regional settings. vbShortTime 4 Display a time using the 24-hour format (hh:mm).
Note: Since all the Named Formats related to the date are relative to regional settings, the only way to consistantly get a date in a standard format is to build it with the month, day and year functions. For example, inserting a date and time into an SQL expression would need something like: month(datetime)&"/"&day(datetime)&"/"&year(datetime) & " " & FormatDateTime(datetime,4)
| file: /techref/language/asp/vbs/vbscript/81.htm, 4KB, , updated: 2007/2/20 18:04, local time: 2008/7/4 15:57,
38.103.63.16:LOG IN
|
| ©2008 These pages are served without commercial sponsorship. (No popup ads, etc...).Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE. Questions? Please DO link to this page! Digg it! <A HREF="http://www.piclist.com/techref/language/asp/vbs/vbscript/81.htm"> Microsoft® Visual Basic® Scripting Edition </A> |
| Did you find what you needed? |
|
PICList 2008 contributors:
o List host: MIT, Site host massmind.org, Top posters @20080704 Apptech, Jinx, Xiaofan Chen, David VanHorn, Alan B. Pearce, Bob Axtell, William \Chops\ Westfield, Cedric Chang, Gerhard Fiedler, bean, * Page Editors: James Newton, David Cary, and YOU! * Roman Black of Black Robotics donates from sales of Linistep stepper controller kits. * Ashley Roll of Digital Nemesis donates from sales of RCL-1 RS232 to TTL converters. * Monthly Subscribers: Shultz Electronics, Larry Williams, David VanHorn, Bryan Whitehouse, Timothy Weber, David Challis. Peter Todd. on-going support is MOST appreciated! * Contributors: Neil Narwani, David Cary, Elemer AM Nyiry, Philip J Taylor, Gus Calabrese of Omegadogs.com, Gautama Venegas, Patrick B. Murphy, William Chops Westfield, Peter Todd, Leslie Ellis |
|
.