An input value that has an explicit time zone specified isĬonverted to UTC using the appropriate offset for that time zone. UTC (Universal Coordinated Time, traditionally known as Greenwich Mean If I'd better use the timestamp to save date/time, then I have to add daylight saving time to it and convert it to Jalali date time and show it to the user, and vice versa.įor timestamp with time zone, the internally stored value is always in Is number 7-a considered 'Asia/Tehran' time zone and daylight saving time when database has 'Asia/Tehran' time zone? Is number 7-c considered daylight saving times? When I wan to query from database, what options is the best in my situation ?ī- SELECT d at time zone 'utc' FROM test Ĭ- SELECT d at time zone 'Asia/Tehran' FROM test Is number 5-a and 5-d saved in 'Asia/Tehran' when database has 'Asia/Tehran' time zone ?
Is number 5-c and 5-f considered daylight saving times when save it or not? What SQL query is the best when I wan to save current date and time ?ī- INSERT INTO test(d) VALUES(now() at time zone 'utc') Ĭ- INSERT INTO test(d) VALUES(now() at time zone 'Asia/Tehran') ĭ- INSERT INTO test(d) VALUES(current_timestamp) Į- INSERT INTO test(d) VALUES(now() at time zone 'utc') į- INSERT INTO test(d) VALUES(now() at time zone 'Asia/Tehran') How can I set TIMEZONE for our database once? I wanna set TIMEZONE for database one time and after that all queries over TIMESTAMPZ columns will be saved and fetched within that TIMEZONE and also it considered daylight saving time ?
What data type is more convenient to save date only? DATE (Gregorian) String (Jalali) or a custom data type? What data type is more convenient to save time only? TIME or TIME WITH TIME ZONE? What data type is more convenient to save date with time? TIMESTAMP ( TIMESTAMP WITHOUT TIMEZONE) or TIMESTAMPZ ( TIMESTAMP WITH TIME ZONE)? IMPORTANT: Sometimes we make a decision and change database server location from Iran to Europe or elsewhere. As a matter of fact daylight saving time is used in Iran. In the first half of year, Iran time is UTC+04:30, but in the rest of year, it is UTC+03:30. Suppose that application users are located in Iran and use Jalali date/time system. I'm gonna to save date and time in my PostgreSQL database and fetch and show it to the user in an appropriate format.
0 kommentar(er)
