Get the App
SLTechnology News&Howtos  ›  Internet Technology  › 

Conversion of QTP time format (YYYYMMDDHHMMSS)

Shulou Source: shulou.com Published: 2022-06-03 06:35:51 11月23日 Update

After looking up a lot of information before, it was written like this:

SendTime = year (sendTime) & right ("00" & month (sendTime), 2) & right ("00" & day (sendTime), 2) & right ("00" & hour (sendTime), 2) & right ("00" & minute (sendTime), 2) & right ("00" & second (sendTime), 2)

But the result of the run is: YYYY- M-DHHMMSS (2012641338), omitting the zero before the month is single digit, and the intended result is 201206041338

Here are the correct results:

Date data is formatted as yyyymmddhhmmss

Function FormatDate (strDate)

FormatDate=year (Cdate (strDate)) & right ("0" & month (Cdate (strDate)), 2) & right ("0" & day (Cdate (strDate)), 2) & right ("0" & hour (Cdate (strDate)), 2) & right ("0" & minute (Cdate (strDate)), 2) & right ("0" & second (Cdate (strDate), 2)

End Function

The result is 201206041338.

Tags: Result format individual digit single digit that is data date month data run time Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Information NVidia Xiaomi Shulou Technology MySQL