date-time format wrong!!

[Ivan Smahin]

Hello Danny,

Tuesday, December 11, 2007, 5:15:52 PM, you wrote:

> Hi List, Ruslan,

> The dateformat in our DB is set to YYYYMMDD.
> But when we use the function NOW(), it stores the date als  
> DDMMYYYY.... WHY?????

set property DateTimeFormat OF DATABASE TO 'kYMD';
set property DateSeparator OF DATABASE TO '-';
select now()

It works - now problems?
Are you sure you set datetimeformat?


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com