Devart Forums

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

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?

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.

We'll consider implementing this behavior in the next version of our product.

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.

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.

Hello,

It has been more than a year since I made this request. Will you please raise the priority on this?

Thanks

John