Date
Get the current date and time, add or subtract days, compute differences, read parts of a date, format and convert between dates, timestamps, epochs, ISO texts and time zones. Other functions give the first and last day of a period, business days, Easter, the next run of a cron expression and durations. Typical uses: compute a due date, group sales by week or quarter.
date adddate addtdate current_msdate current_nsdate curdatedate current_datedate current_timedate current_timestampdate curtimedate curtimestampdate dateadddate dateaddtdate datediffdate datedifftdate ts_to_longdate dt_to_longdate long_to_dtdate long_to_tsdate day_of_monthdate day_of_weekdate day_of_yeardate daynamedate daynamedate diffdate difftdate full_systimestampdate hourdate is_valid_datedate is_valid_datedate is_valid_timedate is_valid_timestampdate is_valid_timestampdate formatdate minutedate monthdate monthnamedate monthnamedate nb_daydate secondedate sysdatedate systimedate systimestampdate nowdate systimestamp_mindate timedate yeardate epochdate timezonedate systimestamp_utcdate first_day_of_monthdate last_day_of_monthdate first_day_of_yeardate last_day_of_yeardate first_day_of_weekdate last_day_of_weekdate week_of_yeardate quarterdate is_leap_yeardate days_in_monthdate is_weekenddate agedate to_isodate from_isodate to_epochdate from_epochdate to_utcdate from_utcdate next_daydate add_business_daysdate nb_business_daysdate is_beforedate is_afterdate truncdate durationdate betweendate convert_tzdate easterdate holidays_frdate holidays_frdate is_holiday_frdate is_holiday_frdate add_business_days_frdate add_business_days_frdate business_days_frdate business_days_frdate iso_weekdate cron_nextdate cron_nextdate duration_parsedate duration_formatdate overlap
date add <date> <field> <number>
Description
Add a number to a date.
Add a number to a date.
Parameters
date: The date - String - required
field: The field to add (DAY|MONTH|YEAR) - String - required
number: The number to add - Number - required
date: The date - String - required
field: The field to add (DAY|MONTH|YEAR) - String - required
number: The number to add - Number - required
admin
date add "1980-06-18" "DAY" 1
mentdb
1980-06-19
Used in use cases (15 recipes)
Date & time developer › Support ticket SLA in business days
Climate & environment scientist › Amplitude and phase of the annual temperature cycle
IoT & sensor engineer › Battery life of a LoRaWAN sensor node
System administrator & DevOps › When will the disk be full?
Accountant & manager › Invoice totals with two VAT rates and the due date
HR & payroll › Age, seniority and next long-service award
and 9 more in the Use cases
Date & time developer › Support ticket SLA in business days
Climate & environment scientist › Amplitude and phase of the annual temperature cycle
IoT & sensor engineer › Battery life of a LoRaWAN sensor node
System administrator & DevOps › When will the disk be full?
Accountant & manager › Invoice totals with two VAT rates and the due date
HR & payroll › Age, seniority and next long-service award
and 9 more in the Use cases
Often used with
date is_weekend · atom get · date is_after · date nb_business_days · date nb_day · date add_business_days · date day_of_week · math floor
date is_weekend · atom get · date is_after · date nb_business_days · date nb_day · date add_business_days · date day_of_week · math floor
date addt <timestamp> <field> <number>
Description
Add a number to a timestamp.
Add a number to a timestamp.
Parameters
timestamp: The timestamp - String - required
field: The field to add (SEC|MIN|HOUR|DAY|MONTH|YEAR) - String - required
number: The number to add - Number - required
timestamp: The timestamp - String - required
field: The field to add (SEC|MIN|HOUR|DAY|MONTH|YEAR) - String - required
number: The number to add - Number - required
admin
date addt "1980-06-18 00:00:00" "DAY" 1
mentdb
1980-06-19 00:00:00
Used in use cases (2 recipes)
Date & time developer › Batch window from a legacy file header
Screen & UI developer (sajax) › Modal booking form with date, datetime, time and number pickers
Date & time developer › Batch window from a legacy file header
Screen & UI developer (sajax) › Modal booking form with date, datetime, time and number pickers
Often used with
date format · string left · concat_var · date dateadd · date dateaddt · date datediff · date datedifft · date diff
date format · string left · concat_var · date dateadd · date dateaddt · date datediff · date datedifft · date diff
date current_ms
Description
Returns the current time in milliseconds.
Returns the current time in milliseconds.
admin
date current_ms
mentdb
1496164604097
Used in use cases (15 recipes)
MQL developer › Cache a slow result in a node with a TTL
Backend & web service developer › Health check endpoint for the load balancer
Date & time developer › Run log header and execution timer
JSON & document store developer › A report cached in a node with a time to live
Debugging & error handling › Follow an order through the logs with a correlation id
Algorithms in MQL › Bubble sort and insertion sort against json sort
and 9 more in the Use cases
MQL developer › Cache a slow result in a node with a TTL
Backend & web service developer › Health check endpoint for the load balancer
Date & time developer › Run log header and execution timer
JSON & document store developer › A report cached in a node with a time to live
Debugging & error handling › Follow an order through the logs with a correlation id
Algorithms in MQL › Bubble sort and insertion sort against json sort
and 9 more in the Use cases
Often used with
execute · script create · script delete · and · while · date now · date sysdate · node create
execute · script create · script delete · and · while · date now · date sysdate · node create
date current_ns
Description
Returns the current time in nanoseconds.
Returns the current time in nanoseconds.
admin
date current_ns
mentdb
823603146305304
Often used with
date add · date age · date curdate · date current_date · date current_ms · date current_time · date current_timestamp · date curtime
date add · date age · date curdate · date current_date · date current_ms · date current_time · date current_timestamp · date curtime
date curdate
Description
Returns the current date.
Returns the current date.
admin
date curdate
mentdb
2015-09-13
Used in use cases (4 recipes)
Date & time developer › Run log header and execution timer
Screen & UI developer (sajax) › Bootstrap page skeleton with an onload call
Files & archives manager › Store a base64 attachment, check it, read it, archive it
Screen & UI developer (sajax) › Approve button: refresh, alert and JavaScript from one action
Date & time developer › Run log header and execution timer
Screen & UI developer (sajax) › Bootstrap page skeleton with an onload call
Files & archives manager › Store a base64 attachment, check it, read it, archive it
Screen & UI developer (sajax) › Approve button: refresh, alert and JavaScript from one action
Often used with
concat_var · include · string decode_b64 · atom get · case · date add · date age · date current_date
concat_var · include · string decode_b64 · atom get · case · date add · date age · date current_date
date current_date
Description
Returns the current date.
Returns the current date.
admin
date current_date
mentdb
2015-09-13
Often used with
date add · date age · date curdate · date current_ms · date current_ns · date current_time · date current_timestamp · date curtime
date add · date age · date curdate · date current_ms · date current_ns · date current_time · date current_timestamp · date curtime
date current_time
Description
Returns the current time.
Returns the current time.
admin
date current_time
mentdb
14:01:22
Often used with
date add · date age · date curdate · date current_date · date current_ms · date current_ns · date current_timestamp · date curtime
date add · date age · date curdate · date current_date · date current_ms · date current_ns · date current_timestamp · date curtime
date current_timestamp
Description
Returns the current timestamp.
Returns the current timestamp.
admin
date current_timestamp
mentdb
2015-09-13 14:01:42
Often used with
date add · date age · date curdate · date current_date · date current_ms · date current_ns · date current_time · date curtime
date add · date age · date curdate · date current_date · date current_ms · date current_ns · date current_time · date curtime
date curtime
Description
Returns the current time.
Returns the current time.
admin
date curtime
mentdb
14:01:57
Often used with
date add · date age · date curdate · date current_date · date current_ms · date current_ns · date current_time · date current_timestamp
date add · date age · date curdate · date current_date · date current_ms · date current_ns · date current_time · date current_timestamp
date curtimestamp
Description
Returns the current timestamp.
Returns the current timestamp.
admin
date curtimestamp
mentdb
2015-09-13 14:02:13
Often used with
date add · date age · date curdate · date current_date · date current_ms · date current_ns · date current_time · date current_timestamp
date add · date age · date curdate · date current_date · date current_ms · date current_ns · date current_time · date current_timestamp
date dateadd <date> <field> <number>
Description
Add a number to a date.
Add a number to a date.
Parameters
date: The date - String - required
field: The field to add (DAY|MONTH|YEAR) - String - required
number: The number to add - Number - required
date: The date - String - required
field: The field to add (DAY|MONTH|YEAR) - String - required
number: The number to add - Number - required
admin
date dateadd "1980-06-18" "DAY" 1
mentdb
1980-06-19
Used in use cases (2 recipes)
Date & time developer › Batch window from a legacy file header
Async developer › Dashboard of the stack queue
Date & time developer › Batch window from a legacy file header
Async developer › Dashboard of the stack queue
Often used with
date addt · date dateaddt · date datediff · date datedifft · date diff · date difft · date format · date hour
date addt · date dateaddt · date datediff · date datedifft · date diff · date difft · date format · date hour
date dateaddt <timestamp> <field> <number>
Description
Add a number to a timestamp.
Add a number to a timestamp.
Parameters
timestamp: The timestamp - String - required
field: The field to add (SEC|MIN|HOUR|DAY|MONTH|YEAR) - String - required
number: The number to add - Number - required
timestamp: The timestamp - String - required
field: The field to add (SEC|MIN|HOUR|DAY|MONTH|YEAR) - String - required
number: The number to add - Number - required
admin
date dateaddt "1980-06-18 00:00:00" "DAY" 1
mentdb
1980-06-19 00:00:00
Used in use cases (14 recipes)
Date & time developer › Batch window from a legacy file header
Async developer › Plan reminders at J+7, J+15 and J+30, then cancel them
Scheduler developer › Prove a job ran with the log table
Event developer › Run a script when a file arrives in a folder
Async developer › Priorities and parallel limit of the stack
Async developer › A run fails, the API comes back, replay it
and 8 more in the Use cases
Date & time developer › Batch window from a legacy file header
Async developer › Plan reminders at J+7, J+15 and J+30, then cancel them
Scheduler developer › Prove a job ran with the log table
Event developer › Run a script when a file arrives in a folder
Async developer › Priorities and parallel limit of the stack
Async developer › A run fails, the API comes back, replay it
and 8 more in the Use cases
Often used with
date now · script create · script delete · string substring · wait · while · and · sequence add
date now · script create · script delete · string substring · wait · while · and · sequence add
date datediff <date> <field> <number>
Description
Subtract a number from a date.
Subtract a number from a date.
Parameters
date: The date - String - required
field: The field to add (DAY|MONTH|YEAR) - String - required
number: The number to add - Number - required
date: The date - String - required
field: The field to add (DAY|MONTH|YEAR) - String - required
number: The number to add - Number - required
admin
date datediff "1980-06-18" "DAY" 1
mentdb
1980-06-17
Used in use cases (2 recipes)
Date & time developer › Batch window from a legacy file header
Files & archives manager › Retention policy: purge the daily exports older than 30 days
Date & time developer › Batch window from a legacy file header
Files & archives manager › Retention policy: purge the daily exports older than 30 days
Often used with
date format · date addt · date dateadd · date dateaddt · date datedifft · date diff · date difft · date first_day_of_month
date format · date addt · date dateadd · date dateaddt · date datedifft · date diff · date difft · date first_day_of_month
date datedifft <timestamp> <field> <number>
Description
Subtract a number from a date.
Subtract a number from a date.
Parameters
timestamp: The timestamp - String - required
field: The field to add (SEC|MIN|HOUR|DAY|MONTH|YEAR) - String - required
number: The number to add - Number - required
timestamp: The timestamp - String - required
field: The field to add (SEC|MIN|HOUR|DAY|MONTH|YEAR) - String - required
number: The number to add - Number - required
admin
date datedifft "1980-06-18 00:00:00" "DAY" 1
mentdb
1980-06-17 00:00:00
Used in use cases (2 recipes)
Date & time developer › Batch window from a legacy file header
Automation architect › Retry the failed runs of a worker
Date & time developer › Batch window from a legacy file header
Automation architect › Retry the failed runs of a worker
Often used with
date addt · date dateadd · date dateaddt · date datediff · date diff · date difft · date format · date hour
date addt · date dateadd · date dateaddt · date datediff · date diff · date difft · date format · date hour
date ts_to_long <timestamp>
Description
Converts a timestamp to a long int.
Converts a timestamp to a long int.
Parameters
timestamp: The timestamp - String - required
timestamp: The timestamp - String - required
admin
date ts_to_long "1980-06-18 00:00:00"
mentdb
330120000000
Often used with
date convert_tz · date dt_to_long · date from_epoch · date from_iso · date from_utc · date long_to_dt · date long_to_ts · date timezone
date convert_tz · date dt_to_long · date from_epoch · date from_iso · date from_utc · date long_to_dt · date long_to_ts · date timezone
date dt_to_long <date>
Description
Converts the date parameter to a long int.
Converts the date parameter to a long int.
Parameters
date: The date - String - required
date: The date - String - required
admin
date dt_to_long "1980-06-18"
mentdb
330120000000
Often used with
date convert_tz · date from_epoch · date from_iso · date from_utc · date long_to_dt · date long_to_ts · date timezone · date to_epoch
date convert_tz · date from_epoch · date from_iso · date from_utc · date long_to_dt · date long_to_ts · date timezone · date to_epoch
date long_to_dt <date>
Description
Converts the date parameter sent by the user to a long int.
Converts the date parameter sent by the user to a long int.
Parameters
date: The date - String - required
date: The date - String - required
admin
date long_to_dt "330120000000"
mentdb
1980-06-18
Often used with
date convert_tz · date dt_to_long · date from_epoch · date from_iso · date from_utc · date long_to_ts · date timezone · date to_epoch
date convert_tz · date dt_to_long · date from_epoch · date from_iso · date from_utc · date long_to_ts · date timezone · date to_epoch
date long_to_ts <date>
Description
Converts a long int to a timestamp.
Converts a long int to a timestamp.
Parameters
date: The date - String - required
date: The date - String - required
admin
date long_to_ts "330120000000"
mentdb
1980-06-18 00:00:00
Used in use cases (2 recipes)
MQL developer › Sort CSV columns: text sort versus numeric sorts
Date & time developer › Time zones, ISO 8601 and epoch for an API
MQL developer › Sort CSV columns: text sort versus numeric sorts
Date & time developer › Time zones, ISO 8601 and epoch for an API
Often used with
atom distinct · atom size · date convert_tz · date dt_to_long · date from_epoch · date from_iso · date from_utc · date long_to_dt
atom distinct · atom size · date convert_tz · date dt_to_long · date from_epoch · date from_iso · date from_utc · date long_to_dt
date day_of_month <date>
Description
Returns the day specified in the date sent in parameter.
Returns the day specified in the date sent in parameter.
Parameters
date: The date - String - required
date: The date - String - required
admin
date day_of_month "1980-06-18"
mentdb
18
Used in use cases (3 recipes)
Date & time developer › One row of a date dimension table
XML, HTML & Word integrator › RSS feed to an HTML news digest
Date & time developer › Monthly billing dates and proration of an upgrade
Date & time developer › One row of a date dimension table
XML, HTML & Word integrator › RSS feed to an HTML news digest
Date & time developer › Monthly billing dates and proration of an upgrade
Often used with
date day_of_week · date days_in_month · date first_day_of_month · date is_leap_year · date monthname · date nb_day · atom get · date add
date day_of_week · date days_in_month · date first_day_of_month · date is_leap_year · date monthname · date nb_day · atom get · date add
date day_of_week <date>
Description
Returns the week value of the date sent as parameter.
Returns the week value of the date sent as parameter.
Parameters
date: The date - String - required
date: The date - String - required
admin
date day_of_week "1980-06-18"
mentdb
3
Used in use cases (7 recipes)
Date & time developer › One row of a date dimension table
Scheduler developer › A frequent job that works only in business hours
HR & payroll › Overtime pay by ISO week
Sales & marketing analyst › Best send time of a newsletter
Date & time developer › Monthly billing dates and proration of an upgrade
Date & time developer › Is the shop open now, and when does it open next
and 1 more in the Use cases
Date & time developer › One row of a date dimension table
Scheduler developer › A frequent job that works only in business hours
HR & payroll › Overtime pay by ISO week
Sales & marketing analyst › Best send time of a newsletter
Date & time developer › Monthly billing dates and proration of an upgrade
Date & time developer › Is the shop open now, and when does it open next
and 1 more in the Use cases
Often used with
date add · json doc · string left · and · atom get · date day_of_month · date days_in_month · date first_day_of_month
date add · json doc · string left · and · atom get · date day_of_month · date days_in_month · date first_day_of_month
date day_of_year <date>
Description
Returns the year value of the date sent as parameter.
Returns the year value of the date sent as parameter.
Parameters
date: The date - String - required
date: The date - String - required
admin
date day_of_year "1980-06-18"
mentdb
170
Used in use cases (3 recipes)
Date & time developer › One row of a date dimension table
Astronomer › Sunrise, sunset and equation of time at the winter solstice
Renewable energy engineer › Sun angles and plane of array irradiance on a tilted PV panel
Date & time developer › One row of a date dimension table
Astronomer › Sunrise, sunset and equation of time at the winter solstice
Renewable energy engineer › Sun angles and plane of array irradiance on a tilted PV panel
Often used with
math deg_to_rad · math rad_to_deg · date day_of_month · date day_of_week · date dayname · date days_in_month · date first_day_of_month · date first_day_of_week
math deg_to_rad · math rad_to_deg · date day_of_month · date day_of_week · date dayname · date days_in_month · date first_day_of_month · date first_day_of_week
date dayname <date>
Description
Returns the day name of the date sent as parameter, in the language of the server (use the form with a language for the same result on every server).
Returns the day name of the date sent as parameter, in the language of the server (use the form with a language for the same result on every server).
Parameters
date: The date - String - required
date: The date - String - required
admin
date dayname "1980-06-18"
mentdb
mercredi (on a French server)
date dayname <date> <language>
Description
Returns the day name of the date in a language (en, fr, es, de, pt-BR...).
Returns the day name of the date in a language (en, fr, es, de, pt-BR...).
Parameters
date: The date - String - required
language: The language (en, fr, es, de, pt-BR...) - String - required
date: The date - String - required
language: The language (en, fr, es, de, pt-BR...) - String - required
admin
date dayname "1980-06-18" "en"
mentdb
Wednesday
admin
date dayname "1980-06-18" "fr"
mentdb
mercredi
Used in use cases (5 recipes)
Date & time developer › Support ticket SLA in business days
Astronomer › Sunrise, sunset and equation of time at the winter solstice
XML, HTML & Word integrator › RSS feed to an HTML news digest
System administrator & DevOps › Do the logs cover the metric window?
Sales & marketing analyst › Best send time of a newsletter
Date & time developer › Support ticket SLA in business days
Astronomer › Sunrise, sunset and equation of time at the winter solstice
XML, HTML & Word integrator › RSS feed to an HTML news digest
System administrator & DevOps › Do the logs cover the metric window?
Sales & marketing analyst › Best send time of a newsletter
Often used with
date is_after · date nb_business_days · date add · date add_business_days · date between · date day_of_month · date day_of_week · date day_of_year
date is_after · date nb_business_days · date add · date add_business_days · date between · date day_of_month · date day_of_week · date day_of_year
date diff <date> <field> <number>
Description
Subtract a number from a date.
Subtract a number from a date.
Parameters
date: The date - String - required
field: The field to add (DAY|MONTH|YEAR) - String - required
number: The number to add - Number - required
date: The date - String - required
field: The field to add (DAY|MONTH|YEAR) - String - required
number: The number to add - Number - required
admin
date diff "1980-06-18" "DAY" 1
mentdb
1980-06-17
Used in use cases (2 recipes)
Date & time developer › Batch window from a legacy file header
HR & payroll › Logins, emails and trial period end of new hires
Date & time developer › Batch window from a legacy file header
HR & payroll › Logins, emails and trial period end of new hires
Often used with
string left · date add · date addt · date dateadd · date dateaddt · date datediff · date datedifft · date day_of_week
string left · date add · date addt · date dateadd · date dateaddt · date datediff · date datedifft · date day_of_week
date difft <timestamp> <field> <number>
Description
Subtract a number from a timestamp.
Subtract a number from a timestamp.
Parameters
timestamp: The timestamp - String - required
field: The field to add (SEC|MIN|HOUR|DAY|MONTH|YEAR) - String - required
number: The number to add - Number - required
timestamp: The timestamp - String - required
field: The field to add (SEC|MIN|HOUR|DAY|MONTH|YEAR) - String - required
number: The number to add - Number - required
admin
date difft "1980-06-18 00:00:00" "DAY" 1
mentdb
1980-06-17 00:00:00
Often used with
date addt · date dateadd · date dateaddt · date datediff · date datedifft · date diff · date format · date hour
date addt · date dateadd · date dateaddt · date datediff · date datedifft · date diff · date format · date hour
date full_systimestamp
Description
Returns the current full timestamp.
Returns the current full timestamp.
admin
date full_systimestamp
mentdb
2015-09-13 14:03:20.395+0400
Often used with
date add · date age · date curdate · date current_date · date current_ms · date current_ns · date current_time · date current_timestamp
date add · date age · date curdate · date current_date · date current_ms · date current_ns · date current_time · date current_timestamp
date hour <time>
Description
Returns the hour value of the time sent as parameter.
Returns the hour value of the time sent as parameter.
Parameters
time: The time - String - required
time: The time - String - required
admin
date hour "12:15:56"
mentdb
12
Used in use cases (4 recipes)
Date & time developer › Batch window from a legacy file header
Script developer › Stack and delay options of a batch script
Scheduler developer › A frequent job that works only in business hours
Sales & marketing analyst › Best send time of a newsletter
Date & time developer › Batch window from a legacy file header
Script developer › Stack and delay options of a batch script
Scheduler developer › A frequent job that works only in business hours
Sales & marketing analyst › Best send time of a newsletter
Often used with
date day_of_week · date systime · date time · script create · script delete · string left · string regexp_replace · and
date day_of_week · date systime · date time · script create · script delete · string left · string regexp_replace · and
date is_valid_date <dateToValidate>
Description
Check if a date is valid.
Check if a date is valid.
Parameters
dateToValidate: The date - String - required
dateToValidate: The date - String - required
admin
date is_valid_date "1980-06-18"
mentdb
1
date is_valid_date <dateToValidate> <format>
Description
Check if a date is valid.
Check if a date is valid.
Parameters
dateToValidate: The date - String - required
format: The date format - String - required
dateToValidate: The date - String - required
format: The date format - String - required
admin
date is_valid_date "1980-06-18" "yyyy-MM-dd"
mentdb
1
Often used with
date addt · date dateadd · date dateaddt · date datediff · date datedifft · date diff · date difft · date format
date addt · date dateadd · date dateaddt · date datediff · date datedifft · date diff · date difft · date format
date is_valid_time <timeToValidate>
Description
Check if a time is valid.
Check if a time is valid.
Parameters
timeToValidate: The time (12:00:01) - String - required
timeToValidate: The time (12:00:01) - String - required
admin
date is_valid_time "12:00:01"
mentdb
1
Often used with
date addt · date dateadd · date dateaddt · date datediff · date datedifft · date diff · date difft · date format
date addt · date dateadd · date dateaddt · date datediff · date datedifft · date diff · date difft · date format
date is_valid_timestamp <timestampToValidate>
Description
Check if a timestamp is valid.
Check if a timestamp is valid.
Parameters
timestampToValidate: The timestamp - String - required
timestampToValidate: The timestamp - String - required
admin
date is_valid_timestamp "1980-06-18 12:00:01"
mentdb
1
date is_valid_timestamp <timestampToValidate> <format>
Description
Check if a timestamp is valid.
Check if a timestamp is valid.
Parameters
timestampToValidate: The timestamp - String - required
format: The format (ex: yyyy MM dd HH:mm:ss) - String - required
timestampToValidate: The timestamp - String - required
format: The format (ex: yyyy MM dd HH:mm:ss) - String - required
admin
date is_valid_timestamp "1980-06-18 12:00:01" "yyyy-MM-dd HH:mm:ss"
mentdb
1
Often used with
date addt · date dateadd · date dateaddt · date datediff · date datedifft · date diff · date difft · date format
date addt · date dateadd · date dateaddt · date datediff · date datedifft · date diff · date difft · date format
date format <timestampToFormat> <formatIn> <formatOut>
Description
Convert a timestamp to another format.
Convert a timestamp to another format.
Parameters
timestampToFormat: The timestamp - String - required
formatIn: The in format (ex: yyyyMMdd HH:mm) - String - required
formatOut: The out format (ex: yyyy MM dd HH:mm:ss) - String - required
timestampToFormat: The timestamp - String - required
formatIn: The in format (ex: yyyyMMdd HH:mm) - String - required
formatOut: The out format (ex: yyyy MM dd HH:mm:ss) - String - required
admin
date format "19800618 12:00" "yyyyMMdd HH:mm" "yyyy-MM-dd HH:mm:ss"
mentdb
1980-06-18 12:00:01
Used in use cases (8 recipes)
Backend & web service developer › Bulk import endpoint with a line by line report
Date & time developer › One row of a date dimension table
String & encoding developer › Mail merge: fill a template from JSON data
JSON & document store developer › Build an order document and its ETag
Screen & UI developer (sajax) › Modal booking form with date, datetime, time and number pickers
Files & archives manager › Retention policy: purge the daily exports older than 30 days
and 2 more in the Use cases
Backend & web service developer › Bulk import endpoint with a line by line report
Date & time developer › One row of a date dimension table
String & encoding developer › Mail merge: fill a template from JSON data
JSON & document store developer › Build an order document and its ETag
Screen & UI developer (sajax) › Modal booking form with date, datetime, time and number pickers
Files & archives manager › Retention policy: purge the daily exports older than 30 days
and 2 more in the Use cases
Often used with
json doc · json uobject · string left · string trim · date addt · date datediff · date first_day_of_month · date last_day_of_month
json doc · json uobject · string left · string trim · date addt · date datediff · date first_day_of_month · date last_day_of_month
date minute <time>
Description
Returns the minute value of the time sent as parameter.
Returns the minute value of the time sent as parameter.
Parameters
time: The time - String - required
time: The time - String - required
admin
date minute "12:15:56"
mentdb
15
Often used with
date addt · date dateadd · date dateaddt · date datediff · date datedifft · date diff · date difft · date format
date addt · date dateadd · date dateaddt · date datediff · date datedifft · date diff · date difft · date format
date month <date>
Description
Returns the month value of a date sent as parameter.
Returns the month value of a date sent as parameter.
Parameters
date: The date - String - required
date: The date - String - required
admin
date month "1980-06-18"
mentdb
6
Used in use cases (3 recipes)
Date & time developer › One row of a date dimension table
HR & payroll › Leave request and balance
Date & time developer › GDPR retention: keep, anonymise or delete customers
Date & time developer › One row of a date dimension table
HR & payroll › Leave request and balance
Date & time developer › GDPR retention: keep, anonymise or delete customers
Often used with
date add · date first_day_of_month · date nb_day · date quarter · atom count · case · date day_of_month · date day_of_week
date add · date first_day_of_month · date nb_day · date quarter · atom count · case · date day_of_month · date day_of_week
date monthname <date>
Description
Returns the month name of the date sent as parameter, in the language of the server (use the form with a language for the same result on every server).
Returns the month name of the date sent as parameter, in the language of the server (use the form with a language for the same result on every server).
Parameters
date: The date - String - required
date: The date - String - required
admin
date monthname "1980-06-18"
mentdb
juin (on a French server)
date monthname <date> <language>
Description
Returns the month name of the date in a language (en, fr, es, de, pt-BR...).
Returns the month name of the date in a language (en, fr, es, de, pt-BR...).
Parameters
date: The date - String - required
language: The language (en, fr, es, de, pt-BR...) - String - required
date: The date - String - required
language: The language (en, fr, es, de, pt-BR...) - String - required
admin
date monthname "1980-06-18" "en"
mentdb
June
admin
date monthname "1980-06-18" "fr"
mentdb
juin
Used in use cases (2 recipes)
Date & time developer › One row of a date dimension table
XML, HTML & Word integrator › RSS feed to an HTML news digest
Date & time developer › One row of a date dimension table
XML, HTML & Word integrator › RSS feed to an HTML news digest
Often used with
date day_of_month · date day_of_week · date day_of_year · date dayname · date days_in_month · date first_day_of_month · date first_day_of_week · date first_day_of_year
date day_of_month · date day_of_week · date day_of_year · date dayname · date days_in_month · date first_day_of_month · date first_day_of_week · date first_day_of_year
date nb_day <date1> <date2>
Description
Get the number of days between two dates
Get the number of days between two dates
Parameters
date1: The date 1 - String - required
date2: The date 2 - String - required
date1: The date 1 - String - required
date2: The date 2 - String - required
admin
date nb_day "1980-06-18" "1980-06-20"
mentdb
2
Used in use cases (15 recipes)
Date & time developer › One row of a date dimension table
Data validation developer › Cross-field rules of a hotel booking
Nuclear & radiation physicist › Activity of a check source today
Climate & environment scientist › Amplitude and phase of the annual temperature cycle
Files & archives manager › Retention policy: purge the daily exports older than 30 days
System administrator & DevOps › Do the logs cover the metric window?
and 9 more in the Use cases
Date & time developer › One row of a date dimension table
Data validation developer › Cross-field rules of a hotel booking
Nuclear & radiation physicist › Activity of a check source today
Climate & environment scientist › Amplitude and phase of the annual temperature cycle
Files & archives manager › Retention policy: purge the daily exports older than 30 days
System administrator & DevOps › Do the logs cover the metric window?
and 9 more in the Use cases
Often used with
json doc · atom get · date add · date first_day_of_month · json iarray · string regexp_replace · bd+ · date is_after
json doc · atom get · date add · date first_day_of_month · json iarray · string regexp_replace · bd+ · date is_after
date seconde <time>
Description
Returns the second value of the time sent as parameter.
Returns the second value of the time sent as parameter.
Parameters
time: The time - String - required
time: The time - String - required
admin
date seconde "12:15:56"
mentdb
56
Often used with
date addt · date dateadd · date dateaddt · date datediff · date datedifft · date diff · date difft · date format
date addt · date dateadd · date dateaddt · date datediff · date datedifft · date diff · date difft · date format
date sysdate
Description
Returns the current date.
Returns the current date.
admin
date sysdate
mentdb
2015-09-13
Used in use cases (21 recipes)
MQL beginner › Your first web service, called with execute
Backend & web service developer › Read server parameters and trace a run in the logs
Date & time developer › Run log header and execution timer
Web service developer › DELETE: idempotent delete with an audit trail
Async developer › Dashboard of the stack queue
Scheduler developer › A frequent job that works only in business hours
and 15 more in the Use cases
MQL beginner › Your first web service, called with execute
Backend & web service developer › Read server parameters and trace a run in the logs
Date & time developer › Run log header and execution timer
Web service developer › DELETE: idempotent delete with an audit trail
Async developer › Dashboard of the stack queue
Scheduler developer › A frequent job that works only in business hours
and 15 more in the Use cases
Often used with
script create · log write · execute · script delete · string substring · cm get · log search · string regexp_extract
script create · log write · execute · script delete · string substring · cm get · log search · string regexp_extract
date systime
Description
Returns the current time.
Returns the current time.
admin
date systime
mentdb
14:04:18
Used in use cases (4 recipes)
Date & time developer › Run log header and execution timer
Script developer › Stack and delay options of a batch script
Execution modes › Stack run postponed until a gate opens
Scheduler developer › A frequent job that works only in business hours
Date & time developer › Run log header and execution timer
Script developer › Stack and delay options of a batch script
Execution modes › Stack run postponed until a gate opens
Scheduler developer › A frequent job that works only in business hours
Often used with
date now · script create · script delete · and · date hour · date is_weekend · date sysdate · date systimestamp
date now · script create · script delete · and · date hour · date is_weekend · date sysdate · date systimestamp
date systimestamp
Description
Returns the current timestamp.
Returns the current timestamp.
admin
date systimestamp
mentdb
2015-09-13 14:04:32
Used in use cases (8 recipes)
Date & time developer › Run log header and execution timer
Execution modes › Stack run postponed until a gate opens
File transfer & remote systems engineer › Watch a drop folder, push files over SSH and notify the head office
API & database integrator › Notify an internal HTTP webhook with a JSON event
Integrator & ETL developer › Nightly copy of an Oracle table into MySQL, committed by batches
System administrator & DevOps › Health report in JSON for the monitoring
and 2 more in the Use cases
Date & time developer › Run log header and execution timer
Execution modes › Stack run postponed until a gate opens
File transfer & remote systems engineer › Watch a drop folder, push files over SSH and notify the head office
API & database integrator › Notify an internal HTTP webhook with a JSON event
Integrator & ETL developer › Nightly copy of an Oracle table into MySQL, committed by batches
System administrator & DevOps › Health report in JSON for the monitoring
and 2 more in the Use cases
Often used with
json doc · json iobject · parameter get value · cm get · date now · date sysdate · date systime · execute
json doc · json iobject · parameter get value · cm get · date now · date sysdate · date systime · execute
date now
Description
Returns the current timestamp.
Returns the current timestamp.
admin
date now
mentdb
2015-09-13 14:04:32
Used in use cases (29 recipes)
MQL developer › Cache a slow result in a node with a TTL
Backend & web service developer › Signed webhook receiver with replay protection
Date & time developer › Run log header and execution timer
Execution modes › Stack run postponed until a gate opens
Async developer › Push a script to the stack and watch it close
Scheduler developer › Prove a job ran with the log table
and 23 more in the Use cases
MQL developer › Cache a slow result in a node with a TTL
Backend & web service developer › Signed webhook receiver with replay protection
Date & time developer › Run log header and execution timer
Execution modes › Stack run postponed until a gate opens
Async developer › Push a script to the stack and watch it close
Scheduler developer › Prove a job ran with the log table
and 23 more in the Use cases
Often used with
script create · script delete · and · wait · while · sequence add · sequence remove · stack
script create · script delete · and · wait · while · sequence add · sequence remove · stack
date systimestamp_min
Description
Returns the current timestamp in minimal format.
Returns the current timestamp in minimal format.
admin
date systimestamp_min
mentdb
20150913140446
Often used with
date add · date age · date curdate · date current_date · date current_ms · date current_ns · date current_time · date current_timestamp
date add · date age · date curdate · date current_date · date current_ms · date current_ns · date current_time · date current_timestamp
date time <timestamp>
Description
Get the time part of a timestamp.
Get the time part of a timestamp.
Parameters
timestamp: The timestamp - String - required
timestamp: The timestamp - String - required
admin
date time "1980-06-18 12:25:56"
mentdb
12:25:56
Used in use cases (3 recipes)
Date & time developer › Batch window from a legacy file header
Sales & marketing analyst › Best send time of a newsletter
Date & time developer › Is the shop open now, and when does it open next
Date & time developer › Batch window from a legacy file header
Sales & marketing analyst › Best send time of a newsletter
Date & time developer › Is the shop open now, and when does it open next
Often used with
string left · date day_of_week · date hour · and · atom find · atom get · atom size · date add
string left · date day_of_week · date hour · and · atom find · atom get · atom size · date add
date year <date>
Description
Returns the year value of the date sent as parameter.
Returns the year value of the date sent as parameter.
Parameters
date: The date - String - required
date: The date - String - required
admin
date year "1980-06-18"
mentdb
1980
Used in use cases (2 recipes)
Date & time developer › One row of a date dimension table
Climate & environment scientist › Dates of the remaining 1.5 C carbon budget
Date & time developer › One row of a date dimension table
Climate & environment scientist › Dates of the remaining 1.5 C carbon budget
Often used with
date add · date day_of_month · date day_of_week · date day_of_year · date days_in_month · date first_day_of_month · date first_day_of_week · date first_day_of_year
date add · date day_of_month · date day_of_week · date day_of_year · date days_in_month · date first_day_of_month · date first_day_of_week · date first_day_of_year
date epoch
Description
Returns the current Unix epoch in seconds.
Returns the current Unix epoch in seconds.
admin
date epoch
mentdb
1761818400
Often used with
date add · date age · date curdate · date current_date · date current_ms · date current_ns · date current_time · date current_timestamp
date add · date age · date curdate · date current_date · date current_ms · date current_ns · date current_time · date current_timestamp
date timezone
Description
Returns the time zone of the server.
Returns the time zone of the server.
admin
date timezone
mentdb
Indian/Reunion
Often used with
date convert_tz · date dt_to_long · date from_epoch · date from_iso · date from_utc · date long_to_dt · date long_to_ts · date to_epoch
date convert_tz · date dt_to_long · date from_epoch · date from_iso · date from_utc · date long_to_dt · date long_to_ts · date to_epoch
date systimestamp_utc
Description
Returns the current UTC timestamp.
Returns the current UTC timestamp.
admin
date systimestamp_utc
mentdb
2026-10-30 10:00:00
Often used with
date add · date age · date curdate · date current_date · date current_ms · date current_ns · date current_time · date current_timestamp
date add · date age · date curdate · date current_date · date current_ms · date current_ns · date current_time · date current_timestamp
date first_day_of_month <date>
Description
Returns the first day of the month.
Returns the first day of the month.
Parameters
date: The date or timestamp - String - required
date: The date or timestamp - String - required
admin
date first_day_of_month "1980-06-18"
mentdb
1980-06-01
Used in use cases (5 recipes)
Date & time developer › One row of a date dimension table
Files & archives manager › Retention policy: purge the daily exports older than 30 days
API & database integrator › IMAP: supplier confirmations only, as JSON, moved to a folder
Date & time developer › Monthly billing dates and proration of an upgrade
Date & time developer › GDPR retention: keep, anonymise or delete customers
Date & time developer › One row of a date dimension table
Files & archives manager › Retention policy: purge the daily exports older than 30 days
API & database integrator › IMAP: supplier confirmations only, as JSON, moved to a folder
Date & time developer › Monthly billing dates and proration of an upgrade
Date & time developer › GDPR retention: keep, anonymise or delete customers
Often used with
date nb_day · date add · date day_of_month · date day_of_week · date days_in_month · date format · date is_leap_year · date last_day_of_month
date nb_day · date add · date day_of_month · date day_of_week · date days_in_month · date format · date is_leap_year · date last_day_of_month
date last_day_of_month <date>
Description
Returns the last day of the month.
Returns the last day of the month.
Parameters
date: The date or timestamp - String - required
date: The date or timestamp - String - required
admin
date last_day_of_month "1980-06-18"
mentdb
1980-06-30
Used in use cases (3 recipes)
Date & time developer › One row of a date dimension table
Files & archives manager › Retention policy: purge the daily exports older than 30 days
Accountant & manager › Invoice totals with two VAT rates and the due date
Date & time developer › One row of a date dimension table
Files & archives manager › Retention policy: purge the daily exports older than 30 days
Accountant & manager › Invoice totals with two VAT rates and the due date
Often used with
date first_day_of_month · date format · date nb_day · date add · date add_business_days · date datediff · date day_of_month · date day_of_week
date first_day_of_month · date format · date nb_day · date add · date add_business_days · date datediff · date day_of_month · date day_of_week
date first_day_of_year <date>
Description
Returns the first day of the year.
Returns the first day of the year.
Parameters
date: The date or timestamp - String - required
date: The date or timestamp - String - required
admin
date first_day_of_year "1980-06-18"
mentdb
1980-01-01
Often used with
date day_of_month · date day_of_week · date day_of_year · date days_in_month · date first_day_of_month · date first_day_of_week · date format · date is_leap_year
date day_of_month · date day_of_week · date day_of_year · date days_in_month · date first_day_of_month · date first_day_of_week · date format · date is_leap_year
date last_day_of_year <date>
Description
Returns the last day of the year.
Returns the last day of the year.
Parameters
date: The date or timestamp - String - required
date: The date or timestamp - String - required
admin
date last_day_of_year "1980-06-18"
mentdb
1980-12-31
Often used with
date day_of_month · date day_of_week · date day_of_year · date days_in_month · date first_day_of_month · date first_day_of_week · date first_day_of_year · date format
date day_of_month · date day_of_week · date day_of_year · date days_in_month · date first_day_of_month · date first_day_of_week · date first_day_of_year · date format
date first_day_of_week <date>
Description
Returns the first day of the ISO week (monday).
Returns the first day of the ISO week (monday).
Parameters
date: The date or timestamp - String - required
date: The date or timestamp - String - required
admin
date first_day_of_week "1980-06-18"
mentdb
1980-06-16
Used in use cases (2 recipes)
Date & time developer › One row of a date dimension table
Date & time developer › Weekly sign-up cohorts and day-14 retention
Date & time developer › One row of a date dimension table
Date & time developer › Weekly sign-up cohorts and day-14 retention
Often used with
date nb_day · date week_of_year · json doc · json iobject · atom get · atom size · date day_of_month · date day_of_week
date nb_day · date week_of_year · json doc · json iobject · atom get · atom size · date day_of_month · date day_of_week
date last_day_of_week <date>
Description
Returns the last day of the ISO week (sunday).
Returns the last day of the ISO week (sunday).
Parameters
date: The date or timestamp - String - required
date: The date or timestamp - String - required
admin
date last_day_of_week "1980-06-18"
mentdb
1980-06-22
Often used with
date day_of_month · date day_of_week · date day_of_year · date days_in_month · date first_day_of_month · date first_day_of_week · date first_day_of_year · date format
date day_of_month · date day_of_week · date day_of_year · date days_in_month · date first_day_of_month · date first_day_of_week · date first_day_of_year · date format
date week_of_year <date>
Description
Returns the ISO 8601 week number.
Returns the ISO 8601 week number.
Parameters
date: The date or timestamp - String - required
date: The date or timestamp - String - required
admin
date week_of_year "1980-06-18"
mentdb
25
Used in use cases (4 recipes)
Date & time developer › One row of a date dimension table
IoT & sensor engineer › Battery life of a LoRaWAN sensor node
HR & payroll › Overtime pay by ISO week
Date & time developer › Weekly sign-up cohorts and day-14 retention
Date & time developer › One row of a date dimension table
IoT & sensor engineer › Battery life of a LoRaWAN sensor node
HR & payroll › Overtime pay by ISO week
Date & time developer › Weekly sign-up cohorts and day-14 retention
Often used with
json iobject · date day_of_week · date first_day_of_week · date nb_day · json doc · json uobject · atom get · atom size
json iobject · date day_of_week · date first_day_of_week · date nb_day · json doc · json uobject · atom get · atom size
date quarter <date>
Description
Returns the quarter (1 to 4).
Returns the quarter (1 to 4).
Parameters
date: The date or timestamp - String - required
date: The date or timestamp - String - required
admin
date quarter "1980-06-18"
mentdb
2
Used in use cases (2 recipes)
Date & time developer › One row of a date dimension table
Date & time developer › GDPR retention: keep, anonymise or delete customers
Date & time developer › One row of a date dimension table
Date & time developer › GDPR retention: keep, anonymise or delete customers
Often used with
date first_day_of_month · date month · date nb_day · atom count · case · date add · date day_of_month · date day_of_week
date first_day_of_month · date month · date nb_day · atom count · case · date add · date day_of_month · date day_of_week
date is_leap_year <date>
Description
Check if the year is a leap year.
Check if the year is a leap year.
Parameters
date: The date, timestamp or year - String - required
date: The date, timestamp or year - String - required
admin
date is_leap_year "1980-06-18"
mentdb
1
Used in use cases (2 recipes)
Date & time developer › One row of a date dimension table
Date & time developer › Monthly billing dates and proration of an upgrade
Date & time developer › One row of a date dimension table
Date & time developer › Monthly billing dates and proration of an upgrade
Often used with
date day_of_month · date day_of_week · date days_in_month · date first_day_of_month · date nb_day · atom get · date add · date day_of_year
date day_of_month · date day_of_week · date days_in_month · date first_day_of_month · date nb_day · atom get · date add · date day_of_year
date days_in_month <date>
Description
Returns the number of days in the month.
Returns the number of days in the month.
Parameters
date: The date or timestamp - String - required
date: The date or timestamp - String - required
admin
date days_in_month "1980-02-18"
mentdb
29
Used in use cases (2 recipes)
Date & time developer › One row of a date dimension table
Date & time developer › Monthly billing dates and proration of an upgrade
Date & time developer › One row of a date dimension table
Date & time developer › Monthly billing dates and proration of an upgrade
Often used with
date day_of_month · date day_of_week · date first_day_of_month · date is_leap_year · date nb_day · atom get · date add · date day_of_year
date day_of_month · date day_of_week · date first_day_of_month · date is_leap_year · date nb_day · atom get · date add · date day_of_year
date is_weekend <date>
Description
Check if the date is a saturday or a sunday.
Check if the date is a saturday or a sunday.
Parameters
date: The date or timestamp - String - required
date: The date or timestamp - String - required
admin
date is_weekend "1980-06-21"
mentdb
1
Used in use cases (9 recipes)
Date & time developer › Support ticket SLA in business days
Scheduler developer › A frequent job that works only in business hours
Control flow › First free meeting slot: nested loops, break and continue
The MQL language in depth › Loops: continue, break, retry with backoff and parallel
IoT & sensor engineer › Battery life of a LoRaWAN sensor node
Accountant & manager › Invoice totals with two VAT rates and the due date
and 3 more in the Use cases
Date & time developer › Support ticket SLA in business days
Scheduler developer › A frequent job that works only in business hours
Control flow › First free meeting slot: nested loops, break and continue
The MQL language in depth › Loops: continue, break, retry with backoff and parallel
IoT & sensor engineer › Battery life of a LoRaWAN sensor node
Accountant & manager › Invoice totals with two VAT rates and the due date
and 3 more in the Use cases
Often used with
date add · date nb_business_days · atom get · atom size · continue · date add_business_days · atom find · break
date add · date nb_business_days · atom get · atom size · continue · date add_business_days · atom find · break
date age <birthdate>
Description
Returns the age in years at the current date.
Returns the age in years at the current date.
Parameters
birthdate: The date or timestamp - String - required
birthdate: The date or timestamp - String - required
admin
date age "1980-06-18"
mentdb
46
Often used with
date add · date curdate · date current_date · date current_ms · date current_ns · date current_time · date current_timestamp · date curtime
date add · date curdate · date current_date · date current_ms · date current_ns · date current_time · date current_timestamp · date curtime
date to_iso <timestamp>
Description
Converts a local timestamp to ISO 8601 with the server offset.
Converts a local timestamp to ISO 8601 with the server offset.
Parameters
timestamp: The timestamp or date - String - required
timestamp: The timestamp or date - String - required
admin
date to_iso "1980-06-18 12:00:00"
mentdb
1980-06-18T12:00:00+04:00
Used in use cases (2 recipes)
Date & time developer › Time zones, ISO 8601 and epoch for an API
System administrator & DevOps › CMDB record with a hashed host id
Date & time developer › Time zones, ISO 8601 and epoch for an API
System administrator & DevOps › CMDB record with a hashed host id
Often used with
date convert_tz · date dt_to_long · date from_epoch · date from_iso · date from_utc · date long_to_dt · date long_to_ts · date systimestamp
date convert_tz · date dt_to_long · date from_epoch · date from_iso · date from_utc · date long_to_dt · date long_to_ts · date systimestamp
date from_iso <iso>
Description
Converts an ISO 8601 date (with or without offset) to a local timestamp.
Converts an ISO 8601 date (with or without offset) to a local timestamp.
Parameters
iso: The ISO 8601 date - String - required
iso: The ISO 8601 date - String - required
admin
date from_iso "1980-06-18T08:00:00Z"
mentdb
1980-06-18 12:00:00
Often used with
date convert_tz · date dt_to_long · date from_epoch · date from_utc · date long_to_dt · date long_to_ts · date timezone · date to_epoch
date convert_tz · date dt_to_long · date from_epoch · date from_utc · date long_to_dt · date long_to_ts · date timezone · date to_epoch
date to_epoch <timestamp>
Description
Converts a local timestamp to a Unix epoch in seconds.
Converts a local timestamp to a Unix epoch in seconds.
Parameters
timestamp: The timestamp or date - String - required
timestamp: The timestamp or date - String - required
admin
date to_epoch "1980-06-18 12:00:00"
mentdb
330163200
Used in use cases (3 recipes)
Date & time developer › Time zones, ISO 8601 and epoch for an API
Astronomer › Julian date, sidereal time and Moon age of an observing night
XML, HTML & Word integrator › GPS track (GPX): distance, climb and average speed
Date & time developer › Time zones, ISO 8601 and epoch for an API
Astronomer › Julian date, sidereal time and Moon age of an observing night
XML, HTML & Word integrator › GPS track (GPX): distance, climb and average speed
Often used with
date from_utc · date convert_tz · date dt_to_long · date duration · date from_epoch · date from_iso · date long_to_dt · date long_to_ts
date from_utc · date convert_tz · date dt_to_long · date duration · date from_epoch · date from_iso · date long_to_dt · date long_to_ts
date from_epoch <epoch>
Description
Converts a Unix epoch in seconds to a local timestamp.
Converts a Unix epoch in seconds to a local timestamp.
Parameters
epoch: The epoch in seconds - Number - required
epoch: The epoch in seconds - Number - required
admin
date from_epoch "330163200"
mentdb
1980-06-18 12:00:00
Used in use cases (2 recipes)
Date & time developer › Time zones, ISO 8601 and epoch for an API
Web & API developer › Decode and build a Snowflake id
Date & time developer › Time zones, ISO 8601 and epoch for an API
Web & API developer › Decode and build a Snowflake id
Often used with
date to_utc · bd* · bd+ · bigdec div · bigdec round · date convert_tz · date dt_to_long · date from_iso
date to_utc · bd* · bd+ · bigdec div · bigdec round · date convert_tz · date dt_to_long · date from_iso
date to_utc <timestamp>
Description
Converts a local timestamp to UTC.
Converts a local timestamp to UTC.
Parameters
timestamp: The timestamp or date - String - required
timestamp: The timestamp or date - String - required
admin
date to_utc "1980-06-18 12:00:00"
mentdb
1980-06-18 08:00:00
Used in use cases (2 recipes)
Date & time developer › Time zones, ISO 8601 and epoch for an API
Web & API developer › Decode and build a Snowflake id
Date & time developer › Time zones, ISO 8601 and epoch for an API
Web & API developer › Decode and build a Snowflake id
Often used with
date from_epoch · bd* · bd+ · bigdec div · bigdec round · date convert_tz · date dt_to_long · date from_iso
date from_epoch · bd* · bd+ · bigdec div · bigdec round · date convert_tz · date dt_to_long · date from_iso
date from_utc <timestamp>
Description
Converts a UTC timestamp to local time.
Converts a UTC timestamp to local time.
Parameters
timestamp: The timestamp or date - String - required
timestamp: The timestamp or date - String - required
admin
date from_utc "1980-06-18 08:00:00"
mentdb
1980-06-18 12:00:00
Used in use cases (2 recipes)
Date & time developer › Time zones, ISO 8601 and epoch for an API
Astronomer › Julian date, sidereal time and Moon age of an observing night
Date & time developer › Time zones, ISO 8601 and epoch for an API
Astronomer › Julian date, sidereal time and Moon age of an observing night
Often used with
date to_epoch · date convert_tz · date dt_to_long · date from_epoch · date from_iso · date long_to_dt · date long_to_ts · date timezone
date to_epoch · date convert_tz · date dt_to_long · date from_epoch · date from_iso · date long_to_dt · date long_to_ts · date timezone
date next_day <date> <day>
Description
Returns the next given day strictly after the date.
Returns the next given day strictly after the date.
Parameters
date: The date or timestamp - String - required
day: The day (monday ... sunday, lundi ... dimanche, or 1 ... 7) - String - required
date: The date or timestamp - String - required
day: The day (monday ... sunday, lundi ... dimanche, or 1 ... 7) - String - required
admin
date next_day "1980-06-18" "monday"
mentdb
1980-06-23
Used in use cases (2 recipes)
Date & time developer › Support ticket SLA in business days
IoT & sensor engineer › Battery life of a LoRaWAN sensor node
Date & time developer › Support ticket SLA in business days
IoT & sensor engineer › Battery life of a LoRaWAN sensor node
Often used with
date add · date is_weekend · date nb_business_days · date add_business_days · date between · date dayname · date duration · date is_after
date add · date is_weekend · date nb_business_days · date add_business_days · date between · date dayname · date duration · date is_after
date add_business_days <date> <number>
Description
Add (or subtract if negative) business days (monday to friday).
Add (or subtract if negative) business days (monday to friday).
Parameters
date: The date or timestamp - String - required
number: The number of business days - Number - required
date: The date or timestamp - String - required
number: The number of business days - Number - required
admin
date add_business_days "1980-06-20" 1
mentdb
1980-06-23
Used in use cases (4 recipes)
Date & time developer › Support ticket SLA in business days
Accountant & manager › Invoice totals with two VAT rates and the due date
Logistics & supply chain › Promised delivery date in business days
Date & time developer › French public holidays and a delivery date in working days
Date & time developer › Support ticket SLA in business days
Accountant & manager › Invoice totals with two VAT rates and the due date
Logistics & supply chain › Promised delivery date in business days
Date & time developer › French public holidays and a delivery date in working days
Often used with
date add · date is_weekend · date between · atom find · atom get · atom size · continue · date dayname
date add · date is_weekend · date between · atom find · atom get · atom size · continue · date dayname
date nb_business_days <date1> <date2>
Description
Get the number of business days (monday to friday) in [date1, date2[.
Get the number of business days (monday to friday) in [date1, date2[.
Parameters
date1: The date 1 - String - required
date2: The date 2 - String - required
date1: The date 1 - String - required
date2: The date 2 - String - required
admin
date nb_business_days "1980-06-16" "1980-06-23"
mentdb
5
Used in use cases (5 recipes)
Date & time developer › Support ticket SLA in business days
IoT & sensor engineer › Battery life of a LoRaWAN sensor node
System administrator & DevOps › Do the logs cover the metric window?
HR & payroll › Leave request and balance
Date & time developer › Run log header and execution timer
Date & time developer › Support ticket SLA in business days
IoT & sensor engineer › Battery life of a LoRaWAN sensor node
System administrator & DevOps › Do the logs cover the metric window?
HR & payroll › Leave request and balance
Date & time developer › Run log header and execution timer
Often used with
date add · date is_weekend · date dayname · date next_day · date add_business_days · date age · date between · date curdate
date add · date is_weekend · date dayname · date next_day · date add_business_days · date age · date between · date curdate
date is_before <timestamp1> <timestamp2>
Description
Check if the first date/timestamp is before the second.
Check if the first date/timestamp is before the second.
Parameters
timestamp1: The timestamp or date 1 - String - required
timestamp2: The timestamp or date 2 - String - required
timestamp1: The timestamp or date 1 - String - required
timestamp2: The timestamp or date 2 - String - required
admin
date is_before "1980-06-18" "1980-06-20 10:00:00"
mentdb
1
Used in use cases (2 recipes)
Date & time developer › Support ticket SLA in business days
Data validation developer › Cross-field rules of a hotel booking
Date & time developer › Support ticket SLA in business days
Data validation developer › Cross-field rules of a hotel booking
Often used with
date between · date is_after · and · atom get · atom size · bd+ · date add · date add_business_days
date between · date is_after · and · atom get · atom size · bd+ · date add · date add_business_days
date is_after <timestamp1> <timestamp2>
Description
Check if the first date/timestamp is after the second.
Check if the first date/timestamp is after the second.
Parameters
timestamp1: The timestamp or date 1 - String - required
timestamp2: The timestamp or date 2 - String - required
timestamp1: The timestamp or date 1 - String - required
timestamp2: The timestamp or date 2 - String - required
admin
date is_after "1980-06-18" "1980-06-20"
mentdb
0
Used in use cases (7 recipes)
Date & time developer › Support ticket SLA in business days
Data validation developer › Cross-field rules of a hotel booking
XML, HTML & Word integrator › RSS feed to an HTML news digest
Accountant & manager › Late payment interest and recovery indemnity
Security engineer › Signed licence key checked offline
Date & time developer › Is the shop open now, and when does it open next
and 1 more in the Use cases
Date & time developer › Support ticket SLA in business days
Data validation developer › Cross-field rules of a hotel booking
XML, HTML & Word integrator › RSS feed to an HTML news digest
Accountant & manager › Late payment interest and recovery indemnity
Security engineer › Signed licence key checked offline
Date & time developer › Is the shop open now, and when does it open next
and 1 more in the Use cases
Often used with
date add · atom get · date between · date nb_day · is empty · string left · and · atom size
date add · atom get · date between · date nb_day · is empty · string left · and · atom size
date trunc <timestamp> <field>
Description
Truncate a timestamp.
Truncate a timestamp.
Parameters
timestamp: The timestamp or date - String - required
field: The field (YEAR|QUARTER|MONTH|WEEK|DAY|HOUR|MIN) - String - required
timestamp: The timestamp or date - String - required
field: The field (YEAR|QUARTER|MONTH|WEEK|DAY|HOUR|MIN) - String - required
admin
date trunc "1980-06-18 12:25:56" "MONTH"
mentdb
1980-06-01 00:00:00
Often used with
date add · date add_business_days · date between · date dayname · date duration · date is_after · date is_before · date is_weekend
date add · date add_business_days · date between · date dayname · date duration · date is_after · date is_before · date is_weekend
date duration <timestamp1> <timestamp2>
Description
Get a readable duration between two timestamps.
Get a readable duration between two timestamps.
Parameters
timestamp1: The timestamp or date 1 - String - required
timestamp2: The timestamp or date 2 - String - required
timestamp1: The timestamp or date 1 - String - required
timestamp2: The timestamp or date 2 - String - required
admin
date duration "1980-06-18 10:00:00" "1980-06-20 12:05:10"
mentdb
2d 2h 5min 10s
Used in use cases (4 recipes)
Date & time developer › Support ticket SLA in business days
XML, HTML & Word integrator › GPS track (GPX): distance, climb and average speed
Integrator & ETL developer › Nightly copy of an Oracle table into MySQL, committed by batches
Date & time developer › Is the shop open now, and when does it open next
Date & time developer › Support ticket SLA in business days
XML, HTML & Word integrator › GPS track (GPX): distance, climb and average speed
Integrator & ETL developer › Nightly copy of an Oracle table into MySQL, committed by batches
Date & time developer › Is the shop open now, and when does it open next
Often used with
date add · date between · date is_after · string substring · and · atom find · atom get · atom size
date add · date between · date is_after · string substring · and · atom find · atom get · atom size
date between <timestamp> <min> <max>
Description
Check if a date/timestamp is between two others (bounds included).
Check if a date/timestamp is between two others (bounds included).
Parameters
timestamp: The timestamp or date - String - required
min: The min - String - required
max: The max - String - required
timestamp: The timestamp or date - String - required
min: The min - String - required
max: The max - String - required
admin
date between "1980-06-18" "1980-06-01" "1980-06-30"
mentdb
1
Used in use cases (4 recipes)
Date & time developer › Support ticket SLA in business days
Data validation developer › Cross-field rules of a hotel booking
Logistics & supply chain › Promised delivery date in business days
Date & time developer › Is the shop open now, and when does it open next
Date & time developer › Support ticket SLA in business days
Data validation developer › Cross-field rules of a hotel booking
Logistics & supply chain › Promised delivery date in business days
Date & time developer › Is the shop open now, and when does it open next
Often used with
date is_after · and · atom get · atom size · date add · date add_business_days · date duration · date is_before
date is_after · and · atom get · atom size · date add · date add_business_days · date duration · date is_before
date convert_tz <timestamp> <from> <to>
Description
Convert a timestamp from a time zone to another (ex: Indian/Reunion, Europe/Paris, UTC, +04:00, LOCAL).
Convert a timestamp from a time zone to another (ex: Indian/Reunion, Europe/Paris, UTC, +04:00, LOCAL).
Parameters
timestamp: The timestamp or date - String - required
from: The source time zone - String - required
to: The target time zone - String - required
timestamp: The timestamp or date - String - required
from: The source time zone - String - required
to: The target time zone - String - required
admin
date convert_tz "1980-06-18 12:00:00" "Indian/Reunion" "Europe/Paris"
mentdb
1980-06-18 10:00:00
Often used with
date dt_to_long · date from_epoch · date from_iso · date from_utc · date long_to_dt · date long_to_ts · date timezone · date to_epoch
date dt_to_long · date from_epoch · date from_iso · date from_utc · date long_to_dt · date long_to_ts · date timezone · date to_epoch
date easter <year>
Description
Date of Easter Sunday of a year (Gregorian calendar)
Date of Easter Sunday of a year (Gregorian calendar)
Parameters
year: The year (1583 to 9999) - Number - required
year: The year (1583 to 9999) - Number - required
admin
date easter 2027
mentdb
2027-03-28
date holidays_fr <year>
Description
French public holidays of a year with their name and their day of the week
French public holidays of a year with their name and their day of the week
Parameters
year: The year - Number - required
year: The year - Number - required
admin
date holidays_fr 2026
mentdb
[{"date": "2026-01-01", "name": "Jour de l'an", "day": "thursday"}, {"date": "2026-04-06", "name": "Lundi de Pâques", "day": "monday"}, {"date": "2026-05-01", "name": "Fête du travail", "day": "friday"}, {"date": "2026-05-08", "name": "Victoire 1945", "day": "friday"}, {"date": "2026-05-14", "name": "Ascension", "day": "thursday"}, {"date": "2026-05-25", "name": "Lundi de Pentecôte", "day": "monday"}, {"date": "2026-07-14", "name": "Fête nationale", "day": "tuesday"}, {"date": "2026-08-15", "name": "Assomption", "day": "saturday"}, {"date": "2026-11-01", "name": "Toussaint", "day": "sunday"}, {"date": "2026-11-11", "name": "Armistice 1918", "day": "wednesday"}, {"date": "2026-12-25", "name": "Noël", "day": "friday"}]
date holidays_fr <year> <region>
Description
French public holidays of a region: alsace (Alsace-Moselle: + Good Friday and 26 December)
French public holidays of a region: alsace (Alsace-Moselle: + Good Friday and 26 December)
Parameters
year: The year - Number - required
region: alsace - String - required
year: The year - Number - required
region: alsace - String - required
admin
date holidays_fr 2026 "alsace"
mentdb
[{"date": "2026-01-01", "name": "Jour de l'an", "day": "thursday"}, {"date": "2026-04-03", "name": "Vendredi saint", "day": "friday"}, {"date": "2026-04-06", "name": "Lundi de Pâques", "day": "monday"}, {"date": "2026-05-01", "name": "Fête du travail", "day": "friday"}, {"date": "2026-05-08", "name": "Victoire 1945", "day": "friday"}, {"date": "2026-05-14", "name": "Ascension", "day": "thursday"}, {"date": "2026-05-25", "name": "Lundi de Pentecôte", "day": "monday"}, {"date": "2026-07-14", "name": "Fête nationale", "day": "tuesday"}, {"date": "2026-08-15", "name": "Assomption", "day": "saturday"}, {"date": "2026-11-01", "name": "Toussaint", "day": "sunday"}, {"date": "2026-11-11", "name": "Armistice 1918", "day": "wednesday"}, {"date": "2026-12-25", "name": "Noël", "day": "friday"}, {"date": "2026-12-26", "name": "Saint Étienne", "day": "saturday"}]
date is_holiday_fr <date>
Description
Check if a date is a French public holiday (1 or 0)
Check if a date is a French public holiday (1 or 0)
Parameters
date: The date yyyy-MM-dd - String - required
date: The date yyyy-MM-dd - String - required
admin
date is_holiday_fr "2026-05-14"
mentdb
1
date is_holiday_fr <date> <region>
Description
Check if a date is a public holiday in a region (alsace)
Check if a date is a public holiday in a region (alsace)
Parameters
date: The date - String - required
region: alsace - String - required
date: The date - String - required
region: alsace - String - required
admin
date is_holiday_fr "2026-04-03" "alsace"
mentdb
1
date add_business_days_fr <date> <n>
Description
Add business days (Monday to Friday, without the French public holidays); a negative number goes back
Add business days (Monday to Friday, without the French public holidays); a negative number goes back
Parameters
date: The date - String - required
n: The number of business days - Number - required
date: The date - String - required
n: The number of business days - Number - required
admin
date add_business_days_fr "2026-12-18" 10
mentdb
2027-01-05
date add_business_days_fr <date> <n> <region>
Description
Add business days with the holidays of a region
Add business days with the holidays of a region
Parameters
date: The date - String - required
n: The number of business days - Number - required
region: alsace - String - required
date: The date - String - required
n: The number of business days - Number - required
region: alsace - String - required
admin
date add_business_days_fr "2026-12-23" 2 "alsace"
mentdb
2026-12-28
Used in use cases (1 recipe)
Accountant & manager › Invoice total, VAT, amount in words and due date
Accountant & manager › Invoice total, VAT, amount in words and due date
date business_days_fr <date1> <date2>
Description
Number of business days between two dates (the first included, the last excluded), without the French public holidays
Number of business days between two dates (the first included, the last excluded), without the French public holidays
Parameters
date1: The first date - String - required
date2: The second date - String - required
date1: The first date - String - required
date2: The second date - String - required
admin
date business_days_fr "2026-05-01" "2026-06-01"
mentdb
17
date business_days_fr <date1> <date2> <region>
Description
Number of business days with the holidays of a region
Number of business days with the holidays of a region
Parameters
date1: The first date - String - required
date2: The second date - String - required
region: alsace - String - required
date1: The first date - String - required
date2: The second date - String - required
region: alsace - String - required
admin
date business_days_fr "2026-12-01" "2027-01-01" "alsace"
mentdb
22
date iso_week <date>
Description
ISO 8601 week of a date (the week of the Thursday), with its year: yyyy-Www
ISO 8601 week of a date (the week of the Thursday), with its year: yyyy-Www
Parameters
date: The date - String - required
date: The date - String - required
admin
date iso_week "2026-12-31"
mentdb
2026-W53
Belongs to the last week of 2026
admin
date iso_week "2027-01-02"
mentdb
2026-W53
date cron_next <cron> <from>
Description
Next execution time of a cron expression (minute hour day_of_month month day_of_week; *, ranges, lists, steps, names jan... and sun...) after a timestamp
Next execution time of a cron expression (minute hour day_of_month month day_of_week; *, ranges, lists, steps, names jan... and sun...) after a timestamp
Parameters
cron: The cron expression - String - required
from: The timestamp yyyy-MM-dd HH:mm:ss - String - required
cron: The cron expression - String - required
from: The timestamp yyyy-MM-dd HH:mm:ss - String - required
admin
date cron_next "30 8 * * mon-fri" "2026-11-06 09:00:00"
mentdb
2026-11-09 08:30:00
date cron_next <cron> <from> <count>
Description
The next n execution times of a cron expression
The next n execution times of a cron expression
Parameters
cron: The cron expression - String - required
from: The timestamp - String - required
count: The number of times - Number - required
cron: The cron expression - String - required
from: The timestamp - String - required
count: The number of times - Number - required
admin
date cron_next "*/15 0-2 * * *" "2026-11-06 23:50:00" 4
mentdb
["2026-11-07 00:00:00", "2026-11-07 00:15:00", "2026-11-07 00:30:00", "2026-11-07 00:45:00"]
First day of each quarter at midnight
admin
date cron_next "0 0 1 1,4,7,10 *" "2026-11-06 12:00:00" 3
mentdb
["2027-01-01 00:00:00", "2027-04-01 00:00:00", "2027-07-01 00:00:00"]
date duration_parse <duration>
Description
Duration in seconds from a text: 2h30, 1d 4h 15m, 90 min, 1 jour 3 heures, PT1H30M (ISO 8601), 01:30:00
Duration in seconds from a text: 2h30, 1d 4h 15m, 90 min, 1 jour 3 heures, PT1H30M (ISO 8601), 01:30:00
Parameters
duration: The duration - String - required
duration: The duration - String - required
admin
date duration_parse "2h30"
mentdb
9000
admin
date duration_parse "PT1H30M15S"
mentdb
5415
admin
date duration_parse "1 jour 3 heures"
mentdb
97200
date duration_format <seconds> <format>
Description
Format a duration in seconds: human (1d 2h 30m), iso (P1DT2H30M) or clock (26:30:00)
Format a duration in seconds: human (1d 2h 30m), iso (P1DT2H30M) or clock (26:30:00)
Parameters
seconds: The duration in seconds - Number - required
format: human, iso or clock - String - required
seconds: The duration in seconds - Number - required
format: human, iso or clock - String - required
admin
date duration_format 95400 "human"
mentdb
1d 2h 30m
admin
date duration_format 95400 "iso"
mentdb
P1DT2H30M
admin
date duration_format 95400 "clock"
mentdb
26:30:00
date overlap <start1> <end1> <start2> <end2>
Description
Overlap of two periods (dates or timestamps): true or false, the common period, its duration in seconds and days
Overlap of two periods (dates or timestamps): true or false, the common period, its duration in seconds and days
Parameters
start1: Start of the first period - String - required
end1: End of the first period - String - required
start2: Start of the second period - String - required
end2: End of the second period - String - required
start1: Start of the first period - String - required
end1: End of the first period - String - required
start2: Start of the second period - String - required
end2: End of the second period - String - required
admin
date overlap "2026-07-01" "2026-07-15" "2026-07-10" "2026-07-20"
mentdb
{"overlap": true, "start": "2026-07-10 00:00:00", "end": "2026-07-15 00:00:00", "seconds": 432000, "days": 5}
