Avatar

Sam Johnson

  • Total activity 24
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 0
  • Subscriptions 5

Activity overview

Latest activity by Sam Johnson
  • Avatar

    Sam Johnson created an article,

    Role-Based Operation Restrictions

    The table below includes all API operations available in HarperDB and indicates whether or not the operation is restricted to super_user roles.  Keep in mind that non-super_user roles will also be ...

  • Avatar

    Sam Johnson created an article,

    Managing Role Permissions

    Role Permissions documentation below for HarperDB version 2.2.0 and above. HarperDB utilizes a Role-Based Access Control (RBAC) framework to manage access to HarperDB instances.  A user is assigned...

  • Avatar

    Sam Johnson created an article,

    OFFSET_UTC

    OFFSET_UTC(date, offset) Returns the UTC date time value with the offset provided included in the return String value formatted as `YYYY-MM-DDTHH:mm:ss.SSSZZ`. The offset argument will be added as ...

  • Avatar

    Sam Johnson created an article,

    GET_SERVER_TIME

    GET_SERVER_TIME() Returns the current date/time value based on the server’s timezone in `YYYY-MM-DDTHH:mm:ss.SSSZZ`  String format. Example: "SELECT GET_SERVER_TIME() AS get_server_time_result" ret...

  • Avatar

    Sam Johnson created an article,

    SQL Date Functions

    HarperDB utilizes Coordinated Universal Time (UTC) in all internal SQL operations. This means that date values passed into any of the functions below will be assumed to be in UTC or in a format tha...

  • Avatar

    Sam Johnson created an article,

    DATE_SUB

    DATE_SUB(date, value, interval) Subtracts the defined amount of time from the date provided in UTC and returns the resulting Unix Timestamp in milliseconds. Accepted interval values:Either string v...

  • Avatar

    Sam Johnson created an article,

    CURRENT_TIMESTAMP

    CURRENT_TIMESTAMP Referencing this variable will evaluate as the current Unix Timestamp in milliseconds. Example: "SELECT CURRENT_TIMESTAMP AS current_timestamp_result" returns{ "current_timestamp...

  • Avatar

    Sam Johnson created an article,

    GETDATE

    GETDATE() Returns the current Unix Timestamp in milliseconds. Example: "SELECT GETDATE() AS getdate_result" returns{ "getdate_result": 1587568845765}

  • Avatar

    Sam Johnson created an article,

    NOW

    NOW() Returns the current Unix Timestamp in milliseconds.  Example: "SELECT NOW() AS now_result" returns{ "now_result": 1587568845765}

  • Avatar

    Sam Johnson created an article,

    DATE

    DATE([date_string]) Formats and returns the date_string argument in UTC in `YYYY-MM-DDTHH:mm:ss.SSSZZ` String format.  If a date_string is not provided, the function will return the current UTC dat...