Hello,
I see that there is a Format property on TOraTimeStamp.
I don't see how to set the format globally for a TOraSession or even a TSmartQuery. Is this possible?
Thanks,
John Dorlon
How to set time zone format
Re: How to set time zone format
Currently ODAC doesn't allow you to specify the format in TOraSession or TOraQuery. We'll try to implement such functionality. Could you send us a sample project or code fragement that we could use for testing?
Re: How to set time zone format
Well, I know I said TOraSession or TSmartQuery initially, but really, if I could just set it globally, that would work for me.
So I'd just like to do something like:
DefaultTimeZoneFormat := 'TZR'; // (I just made this variable name up)
Then this function in OraCall could be changed to:
and then TZR would be used everywhere, such as query results, editing data from TDBGrid, etc.
I'm not sure if any other changes would be needed to accomplish this.
So I'd just like to do something like:
DefaultTimeZoneFormat := 'TZR'; // (I just made this variable name up)
Then this function in OraCall could be changed to:
Code: Select all
function DefaultOCITimeStampWithTZFormat(Precision: Byte = 6): string;
begin
if DefaultTimeZoneFormat = '' then
Result := DefaultOCITimeStampFormat + ' TZH:TZM'
else
Result := DefaultOCITimeStampFormat + ' ' + DefaultTimeZoneFormat;
end;
I'm not sure if any other changes would be needed to accomplish this.
Re: How to set time zone format
We'll consider implementing this behavior in the next version of our product.
Re: How to set time zone format
Thanks. Here is why it matters:
A user has inserted a timestamp with region, such as:
01.04.2021 12:00:00,0000 Europe/Berlin
Then when editing in a grid with TSmartQuery, it is shown as:
01.04.2021 12:00:00,0000 +02:00
Which is fine, but after editing, the region information is lost even if queried specifically with 'TZR'. So the user wants to set our application to use TZR instead of TZH:TZM.
A user has inserted a timestamp with region, such as:
01.04.2021 12:00:00,0000 Europe/Berlin
Then when editing in a grid with TSmartQuery, it is shown as:
01.04.2021 12:00:00,0000 +02:00
Which is fine, but after editing, the region information is lost even if queried specifically with 'TZR'. So the user wants to set our application to use TZR instead of TZH:TZM.
Re: How to set time zone format
Thank you for clarifying. We understand the value of this feature and will try to add the ability to set time zone format in a future release.
Re: How to set time zone format
Hello,
It has been more than a year since I made this request. Will you please raise the priority on this?
Thanks
John
It has been more than a year since I made this request. Will you please raise the priority on this?
Thanks
John