![]() ![]() Last 2 digits of ISO 8601 week-numbering year Last 3 digits of ISO 8601 week-numbering year ![]() ISO 8601 week-numbering year (4 or more digits) ![]() (See also to_timestamp(double precision) in Table 9.33.) To_timestamp ( text, text ) → timestamp with time zoneĬonverts string to time stamp according to the given format. To_char(interval '15h 2m 12s', 'HH24:MI:SS') → 15:02:12Ĭonverts number to string according to the given format available for integer, bigint, numeric, real, double precision.Ĭonverts string to date according to the given format.Ĭonverts string to numeric according to the given format. To_char(timestamp ' 17:31:12.66', 'HH12:MI:SS') → 05:31:12Ĭonverts interval to string according to the given format. To_char ( timestamp with time zone, text ) → textĬonverts time stamp to string according to the given format. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |