Setting date format permanently for SQL Anywhere DB

Classic Servoy
1

Hi

We are in the process of migrating to Servoy 5 (with SQLAnywhere 11) and an “old friend” reappears .-)
How do I permanently set the date format to:

set option date_order = ‘dmy’;

In this thread: viewtopic.php?p=47691

Chris Gruber offered

set option public.date_order=‘dmy’;
set permanent;

But when I try it doesn’t set the date format permanently for the database.

Regards, Robert

2

Hi Robert!

Have you tried this approach?

http://en.allexperts.com/q/Sybase-2153/ … Format.htm

I remember having seen an Option in Sybase, where you can set your default language, which might be affecting the DATETIME Format as well… But thats just a guess.

Regards

Jan

3

Hi Jan

I found it (again). I knew we had set it before but couldn’t find it anymore. The setting is to be set at the database (level). Selecting the database and right click gives the options key/values to edit. And there is one key - date_order - to set to ‘dmy’ in our case.

Thanks, Robert