Socrata was acquired by Tyler Technologies in 2018 and is now the Data and Insights division of Tyler. The platform is still powered by the same software formerly known as Socrata but you will see references to Data & Insights going forward.

to_floating_timestamp

Function: to_floating_timestamp
 Turn a text value into a floating datetime. "Floating" means the timezone isn't specified, ie: the time "floats" depending on where you are. The formatting string can be constructed with the following tokens Spec. Example Description -- Date Specifiers %Y 2001 The full proleptic Gregorian year, zero-padded to 4 digits. %C 20 The proleptic Gregorian year divided by 100, zero-padded to 2 digits. %y 01 The proleptic Gregorian year modulo 100, zero-padded to 2 digits. %m 07 Month number (01--12), zero-padded to 2 digits. %b Jul Abbreviated month name. Always 3 letters. %B July Full month name. Also accepts corresponding abbreviation in parsing. %h Jul Same as %b. %d 08 Day number (01--31), zero-padded to 2 digits. %e 8 Same as %d but space-padded. Same as %_d. %a Sun Abbreviated weekday name. Always 3 letters. %A Sunday Full weekday name. Also accepts corresponding abbreviation in parsing. %w 0 Sunday = 0, Monday = 1, ..., Saturday = 6. %u 7 Monday = 1, Tuesday = 2, ..., Sunday = 7. (ISO 8601) %U 28 Week number starting with Sunday (00--53), zero-padded to 2 digits. %W 27 Same as %U, but week 1 starts with the first Monday in that year instead. %G 2001 Same as %Y but uses the year number in ISO 8601 week date. %g 01 Same as %y but uses the year number in ISO 8601 week date. %V 27 Same as %U but uses the week number in ISO 8601 week date (01--53). %j 189 Day of the year (001--366), zero-padded to 3 digits. %D 07/08/01 Month-day-year format. Same as %m/%d/%y. %x 07/08/01 Same as %D. %F 2001-07-08 Year-month-day format (ISO 8601). Same as %Y-%m-%d. %v 8-Jul-2001 Day-month-year format. Same as %e-%b-%Y. -- Time Specifiers %H 00 Hour number (00--23), zero-padded to 2 digits. %k 0 Same as %H but space-padded. Same as %_H. %I 12 Hour number in 12-hour clocks (01--12), zero-padded to 2 digits. %l 12 Same as %I but space-padded. Same as %_I. %P am am or pm in 12-hour clocks. %p AM AM or PM in 12-hour clocks. %M 34 Minute number (00--59), zero-padded to 2 digits. %S 60 Second number (00--60), zero-padded to 2 digits. %f 026490000 The fractional seconds (in nanoseconds) since last whole second. %.f .026490 Similar to .%f but left-aligned. %.3f .026 Similar to .%f but left-aligned but fixed to a length of 3. %.6f .026490 Similar to .%f but left-aligned but fixed to a length of 6. %.9f .026490000 Similar to .%f but left-aligned but fixed to a length of 9. %R 00:34 Hour-minute format. Same as %H:%M. %T 00:34:60 Hour-minute-second format. Same as %H:%M:%S. %X 00:34:60 Same as %T. %r 12:34:60 AM Hour-minute-second format in 12-hour clocks. Same as %I:%M:%S %p. -- Time zone specifiers %Z ACST Formatting only: Local time zone name. %z +0930 Offset from the local time to UTC (with UTC being +0000). %:z +09:30 Same as %z but with a colon. -- Date and Time specifiers %c Sun Jul 8 00:34:60 2001 ctime date & time format. Same as %a %b %e %T %Y sans . %+ 2001-07-08T00:34:60.026490+09:30 ISO 8601 / RFC 3339 date & time format. %s 994518299 UNIX timestamp, the number of seconds since 1970-01-01 00:00 UTC. -- Special Specifiers %t Literal tab ( ). %n Literal newline ( ). %% Literal percent sign. Turn an absolute point in time into a timestamp in the given time zone. Examples: to_floating_timestamp('4/1/2018 1:05:26AM','%m/%d/%Y %I:%M:%S%P') -- Result: "2018-04-01T01:05:26"
Signatures
calendar_date -> calendar_date text, text -> calendar_date text -> calendar_date date, text -> calendar_date
close