Jump to content

Recommended Posts

Posted

Hi all,

I have for example this Time pattern: " 2012-06-27 10-37-50 " (YYYY-MM-DD hh-mm-ss)

How can I convert it to an absoulte time, so I can add num of seconds up or dowwn for example

And then convert it back to the pattern (YYYY-MM-DD hh-mm-ss)

Is it possible?

Thanks

Posted (edited)

Change the format from YYY-MM-DD HH-MM-SS to YYYY/MM/DD HH:MM:SS and then use function _DateAdd.

$sDate = StringReplace("2012-06-27 10-37-50", "-", "/", 2)
$sDate = StringReplace($sDate, "-", ":", 2)
ConsoleWrite($sDate & @CRLF)
Edited by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Posted (edited)

Hi,

I'm using :

Local $iDateCalc = _DateDiff('s', "1970/01/01 00:00:00", $sDate)
MsgBox(4096, "", "Number of seconds since EPOCH: " & $iDateCalc)

iDateCalcNew = iDateCalc + 7

How can I convert this value of iDateCalcNew (Seconds since 1970) back to Date and Time format?

Edited by atzoref
Posted

Use this function written by trancexx.

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Posted

Try this:

#include <Date.au3>

$sDateStart = "1970/01/01 00:00:00"
$iSeconds = 10
$sNewDate = _DateAdd("s", $iSeconds, $sDateStart )
ConsoleWrite('@@ Debug(' & @ScriptLineNumber & ') : $sNewDate = ' & $sNewDate & @crlf & '>Error code: ' & @error & @crlf) ;### Debug Console

Br,

UEZ

Please don't send me any personal message and ask for support! I will not reply!

Selection of finest graphical examples at Codepen.io

The own fart smells best!
Her 'sikim hıyar' diyene bir avuç tuz alıp koşma!
¯\_(ツ)_/¯  ٩(●̮̮̃•̃)۶ ٩(-̮̮̃-̃)۶ૐ

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...