date-time format wrong!!

[Danny Lewkin]

Hi Ivan,

Can you reproduce it?
Should I put it into mantis?


Op 11-dec-07, om 16:38 heeft Danny Lewkin het volgende geschreven:

> Hi Ivan,
>
> 1) well, in VSTUDIO the dateformat for that DB is set to YYYYMMDD...
>
> 2) And this is how it's written in our db-creation-program :
>
>     DateFormat = EVDateFormat.kYMD
>     DateSep = "-"
>     TimeSep = ":"
>
> these settings are accepted and shown in the same way when we open  
> the DB with VStudio...
>
> 3) Executing the 3 lines :
>
>> set property DateTimeFormat OF DATABASE TO 'kYMD';
>> set property DateSeparator OF DATABASE TO '-';
>> select now()
>
> in SQL editor in VStudio, ALSO returns WRONG formatted date!!
> Like this : 11-12-2007 16:35:41:123
>
> DB is under SERVER, and Vstudio and VServer are running under MAC  
> OSX, latest update.
> Version of Vstudio and VServer = 3.5.1
>
>
> Greetz,
>
> Danny
>
>
>
>
>
> Op 11-dec-07, om 16:29 heeft Ivan Smahin het volgende geschreven:
>
>> 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
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina