( start1, length1) OVERLAPS ( start2, length2) In addition to these functions, the SQL OVERLAPS operator is supported: ( start1, end1) OVERLAPS ( start2, end2) Make_timestamptz(2013, 7, 15, 8, 15, 23.5)Ĭurrent date and time (start of current statement) see Section 9.9.4Ĭurrent date and time (like clock_timestamp, but as a text string) see Section 9.9.4 When timezone is not specified, then current time zone is used. ![]() Make_timestamptz( year int, month int, day int, hour int, min int, sec double precision, )Ĭreate timestamp with time zone from year, month, day, hour, minute and seconds fields. Make_timestamp( year int, month int, day int, hour int, min int, sec double precision)Ĭreate timestamp from year, month, day, hour, minute and seconds fields Make_time( hour int, min int, sec double precision)Ĭreate time from hour, minute and seconds fields ![]() Make_interval( years int DEFAULT 0, months int DEFAULT 0, weeks int DEFAULT 0, days int DEFAULT 0, hours int DEFAULT 0, mins int DEFAULT 0, secs double precision DEFAULT 0.0)Ĭreate interval from years, months, weeks, days, hours, minutes and seconds fields Justify_interval(interval '1 mon -1 hour')Ĭreate date from year, month and day fields Test for finite time stamp (not +/-infinity)Īdjust interval so 30-day time periods are represented as monthsĪdjust interval so 24-hour time periods are represented as daysĪdjust interval using justify_days and justify_hours, with additional sign adjustments Truncate to specified precision see also Section 9.9.2ĭate_trunc('hour', timestamp ' 20:38:40')ĭate_trunc('hour', interval '2 days 3 hours 40 minutes')Įxtract(month from interval '2 years 3 months') Get subfield (equivalent to extract) see Section 9.9.1ĭate_part('month', interval '2 years 3 months') Subtract arguments, producing a "symbolic" result that uses years and months, rather than just daysĬurrent date and time (changes during statement execution) see Section 9.9.4Ĭurrent date and time (start of current transaction) see Section 9.9.4 Interval '1 hour' / double precision '1.5' ![]() Double precision '3.5' * interval '1 hour'
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |