date-time format wrong!!

[Mr. Bart Pietercil]

Hi List, Ruslan


submitted into Mantis

http://valentina-db.com/bt/view.php?id=2917

This bug is VServer only

Bart Pietercil


On 11-dec-07, at 18:41, Ruslan Zasukhin wrote:

> On 11/12/07 5:38 PM, "Danny Lewkin" <daniel.lewkin at cognosis.be> wrote:
>
>> 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
>
> May be issue only if db under vserver ?
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina