![]() ![]() Postgres=# postgres=# - Setting date formats postgres=# postgres=# SET DATESTYLE TO ISO,US SET postgres=# postgres=# SHOW DATESTYLE DateStyle. The same compile-time option also determines whether time and interval values are stored as floating-point or eight-byte integers. However eight-byte integer timestamps have a more limited range of dates than shown above: from 4713 BC up to 294276 AD. ![]() ![]() When timestamp values are stored as eight-byte integers (a compile-time option), microsecond precision is available over the full range of values. Microsecond precision is achieved for dates within a few years of, but the precision degrades for dates further away. Timestamp values are stored as seconds before or after midnight. Note: When timestamp values are stored as double precision floating-point numbers (currently the default), the effective limit of precision may be less than 6. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |