Jump to content

Recommended Posts

Posted
$sMsg = '2017-09-04 18:42:38'
_DateDiff ('h', $sMsg , _NowCalc() )

I could not find anything recent, so I thought I would put it here.

The '2017-09-04' date is a typical SQL timestamp. The _NowCalc() is a typical AutoIt date calculator.  Much to my surprise and delight, _DateDiff works correctly with these two dates without any prior conversion.

I am guessing that internally the separating characters (-/) get ignore. :)

Does save on additional code. :)

Skysnake

Skysnake

Why is the snake in the sky?

  • Moderators
Posted

Skysnake,

  Quote

I am guessing that internally the separating characters (-/) get ignore

Expand  

See _DateTimeSplit for acceptable DTM formats.

M23

Public_Domain.png.2d871819fcb9957cf44f4514551a2935.png Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind

Open spoiler to see my UDFs:

  Reveal hidden contents

 

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...