atzoref Posted June 27, 2012 Share Posted June 27, 2012 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 Link to comment Share on other sites More sharing options...
water Posted June 27, 2012 Share Posted June 27, 2012 (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 June 27, 2012 by water My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
atzoref Posted June 27, 2012 Author Share Posted June 27, 2012 (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 June 27, 2012 by atzoref Link to comment Share on other sites More sharing options...
water Posted June 27, 2012 Share Posted June 27, 2012 Use this function written by trancexx. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
UEZ Posted June 27, 2012 Share Posted June 27, 2012 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!¯\_(ツ)_/¯ ٩(●̮̮̃•̃)۶ ٩(-̮̮̃-̃)۶ૐ Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now