date-time format wrong!!
Ivan Smahin
ivan_smahin at paradigmasoft.com
Tue Dec 11 09:29:25 CST 2007
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
More information about the Valentina
mailing list