atzoref Posted June 27, 2012 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
water Posted June 27, 2012 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 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
atzoref Posted June 27, 2012 Author 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
water Posted June 27, 2012 Posted June 27, 2012 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
UEZ Posted June 27, 2012 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!¯\_(ツ)_/¯ ٩(●̮̮̃•̃)۶ ٩(-̮̮̃-̃)۶ૐ
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