Query input date instead of SCP timestamp
I am trying to get a query built that I can enter simple dates into rather than the timestamp that SCP uses for calculations.
I have tried the following
I have tried the following
- (UNIX_TIMESTAMP(DATE('2013-01-01 00:00:00')) * 1000))
- (UNIX_TIMESTAMP(STR_TO_DATE('2013-01-01 00:00:00')) * 1000)
But I get exceptions such as: java.sql.SQLException: 'DATE' is not a recognized built-in function name
Topic Participants
gdresser
SupportCenter Support
New to M365 Manager Plus?
New to M365 Manager Plus?
New to RecoveryManager Plus?
New to RecoveryManager Plus?
New to Exchange Reporter Plus?
New to Exchange Reporter Plus?
New to SharePoint Manager Plus?
New to SharePoint Manager Plus?
New to ADManager Plus?