Re: Returning timestamp with timezone at specified timezone irrespective of client timezone

2020-09-27 Thread Greg Smith
only working on and knowledgeable regarding the database. > > Thanks for your help, > > Drew > > At 2020-09-27T19:37:39-04:00, Greg Smith sent: >> Is it really a requirement to hold the datetime in the database >> actually in the specified time zone ? Usual practice is t

Re: Returning timestamp with timezone at specified timezone irrespective of client timezone

2020-09-27 Thread Greg Smith
Is it really a requirement to hold the datetime in the database actually in the specified time zone ? Usual practice is to hold UTC only and convert when necessary to user-configured (or specified) or column-specified time zone perhaps only when transferring to/from the db or when otherwise nece