sqlDateTime

const sqlDateTime: RegExp = /^(?!0000)\d{4}-(0[1-9]|1[0-2])-(0[1-9]|[12][0-9]|3[01]) (0[0-9]|1[0-9]|2[0-3]):[0-5][0-9]:[0-5][0-9](?:\.[0-9]{0,9})?$/;

RegExp matching a SQL timestamp literal without a time zone: YYYY-MM-DD HH:MM:SS[.fffffffff].

Examples

import { sqlDateTime } from "@northguild/gmt";

sqlDateTime.test("2024-03-15 14:30:00.123456789") // true
sqlDateTime.test("0001-01-01 00:00:00") // true (the first year SQL allows)
sqlDateTime.test("2024-03-15 14:30:00.") // true (period with no fraction)
sqlDateTime.test("2024-03-15 14:30") // false (seconds are required)
sqlDateTime.test("0000-01-01 00:00:00") // false (year outside 0001–9999)
sqlDateTime.test("+002024-03-15 14:30:00") // false (expanded year)
sqlDateTime.test("2024-03-15T14:30:00") // false (T separator)
sqlDateTime.test("2024-3-5 14:30:00") // false (unpadded)
sqlDateTime.test("2024-03-15 14:30:60") // false (leap second; GMT rejects it)

Source

regex/sql-date-time.ts