Format current date and time in VBScript

by

Date formatting options are limited in Classic ASP by default, there is a function FormatDateTime() which can format your date is various ways based on the servers regional settings.

For more control over date formatting though there are built in date time functions

  • Year(date) – Returns a whole number representing the year. Passing Date() will give back the current year.

  • Month(date) – Returns a whole number between 1 and 12, inclusive, representing the month of the year. Passing Date() will return the current month of the year.

  • MonthName(month[, abbv]) – Returns a string indicating the specified month. Passing in Month(Date()) as the month will give back the current Month string. As suggested by @Martha

  • Day(date) – Returns a whole number between 1 and 31, inclusive, representing the day of the month. Passing Date() will return the current day of the month.

  • Hour(time) – Returns a whole number between 0 and 23, inclusive, representing the hour of the day. Passing Time() will return the current hour.

  • Minute(time) – Returns a whole number between 0 and 59, inclusive, representing the minute of the hour. Passing Time() will return the current minute.

  • Second(time) – Returns a whole number between 0 and 59, inclusive, representing the second of the minute. Passing Time() will return the current second.

IMPORTANT:
When formatting date / time values, always store the date / time value first. Also, any needed calculations (DateAdd() etc.) should be applied before attempting to format or you will get unexpected results.

The functions Month(), Day(), Hour(), Minute() and Second() all return whole numbers. Luckily there is an easy workaround that lets you pad these values quickly Right("00" & value, 2) what it does is append 00 to the front of the value then from the right take the first two characters. This ensures that all single digit values return prefixed with a 0.

Dim dd, mm, yy, hh, nn, ss
Dim datevalue, timevalue, dtsnow, dtsvalue

'Store DateTimeStamp once.
dtsnow = Now()

'Individual date components
dd = Right("00" & Day(dtsnow), 2)
mm = Right("00" & Month(dtsnow), 2)
yy = Year(dtsnow)
hh = Right("00" & Hour(dtsnow), 2)
nn = Right("00" & Minute(dtsnow), 2)
ss = Right("00" & Second(dtsnow), 2)

'Build the date string in the format yyyy-mm-dd
datevalue = yy & "-" & mm & "-" & dd
'Build the time string in the format hh:mm:ss
timevalue = hh & ":" & nn & ":" & ss
'Concatenate both together to build the timestamp yyyy-mm-dd hh:mm:ss
dtsvalue = datevalue & " " & timevalue

Call Response.Write(dtsvalue)

Note: You can build the date string in one call but decided to break it down into the three variables to make it easier to read.

More Related Contents:

  1. Out of memory Microsoft VBScript runtime error 800a0007
  2. Daylight saving time and time zone best practices [closed]
  3. Kotlin DateTimeParseException
  4. Any good libraries for parsing JSON in Classic ASP? [closed]
  5. How to get the current time as datetime
  6. How can I post data using cURL in asp classic?
  7. How do you specify the date format used when JAXB marshals xsd:dateTime?
  8. Why are date/time values interpreted incorrectly when patching/saving?
  9. Convert UTC string to time object
  10. ASP JSON: Object not a collection
  11. What is the difference between UTC and GMT?
  12. Aggregate Daily Data to Month/Year intervals
  13. Calculate the number of weekdays between 2 dates in R
  14. IE JavaScript date parsing error
  15. ADODB.Parameters error ‘800a0e7c’ Parameter object is improperly defined. Inconsistent or incomplete information was provided
  16. Using DateTime properties in Code-First Entity Framework and SQL Server
  17. ASP: request.form is not returning value?
  18. Compare values of two arrays – classic asp
  19. How do I convert an interval into a number of hours with postgres?
  20. How to make a parametrized SQL Query on Classic ASP?
  21. How precise is the internal clock of a modern PC?
  22. Aggregating hourly data into daily aggregates
  23. HTTP GET Request, ASP – I’m lost!
  24. Error trying to call stored procedure with prepared statement
  25. Twig date difference
  26. How to resolve “The requested URL was rejected. Please consult with your administrator.” error?
  27. Classic ASP (VBScript) convert HTML codes to plain text
  28. How to encrypt in VBScript using AES?
  29. How to read CSV files line by line in VBScript
  30. How to get timezone, Language and County Id in flutter by the location of device in flutter?

Leave a Comment