On 10-5-2018 17:51, Adriano dos Santos Fernandes wrote:
On 10/05/2018 12:27, Alex Peshkoff via Firebird-devel wrote:
On 05/10/18 18:21, Adriano dos Santos Fernandes wrote:
Hi!

I want to create a virtual table that lists available time zones.

For now there is RDB$ (non-virtual), MON$ (virtual, but all about
monitoring), SEC$ (security plugin).

What prefix should TIME_ZONES have?

Can you provide a small sample? What columns will it have, when new
row is added to it, may be something else important from your POV.

Note that data is for server (i.e., all databases will list the same
info) and it's read only.

Basic info:
ID NUMERIC
NAME VARCHAR

Would that name be the full name like Europe/Amsterdam, or would it also include the imprecise (duplicates are possible) like CET?

Mark
--
Mark Rotteveel

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to