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: 2024/9/1 02:10,
18.219.17.88:LOG IN
|
©2024 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? <A HREF="http://techref.massmind.org/techref/language/asp/VBS/VBSCRIPT/81.htm"> Microsoft® Visual Basic® Scripting Edition </A> |
Did you find what you needed? |
Welcome to massmind.org! |
Welcome to techref.massmind.org! |
.