Avatar

Sam Johnson

  • Total activity 21
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 0
  • Subscriptions 4

Activity overview

Latest activity by Sam Johnson
  • 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...

  • Avatar

    Sam Johnson created an article,

    DATE_DIFF

    DATE_DIFF(date_1, date_2[, interval]) Returns the difference between the two date values passed based on the interval as a Number.  If an interval is not provided, the function will return the diff...

  • Avatar

    Sam Johnson created an article,

    DATE_ADD

    DATE_ADD(date, value, interval) Adds the defined amount of time to the date provided in UTC and returns the resulting Unix Timestamp in milliseconds. Accepted interval values:Either string value (k...