<html><head><meta http-equiv="Content-Type" content="text/html charset=iso-8859-1"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I am running:<div><br></div><div> vserver_x64 (Type x64, Server 5.4.3, Kernel 5.4.3<div><br></div><div><br></div><div>I have attempted using sql to set up date-time </div><div><br></div><div>vMyDB.SQLExecute("SET PROPERTY DateTimeFormat,DateSeparator,TimeSeparator OF DATABASE TO 'kYMD','-',':'")</div><div><br></div><div>Is there any reason why that doesn't work? </div><div> </div><div><br><div><div>On Sep 27, 2013, at 4:00 PM, william humphrey <<a href="mailto:bill@bluewatermaritime.com">bill@bluewatermaritime.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr">Also what version vServer are you using?</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Sep 27, 2013 at 2:44 PM, Ruslan Zasukhin <span dir="ltr"><<a href="mailto:ruslan_zasukhin@valentina-db.com" target="_blank">ruslan_zasukhin@valentina-db.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 9/27/13 8:54 PM, "Joseph Morgan" <<a href="mailto:joseph@checkos.com">joseph@checkos.com</a>> wrote:<br>
<br>
Hi Joseph,<br>
<div class="im"><br>
> I am getting this error message when adding a row to a table:<br>
> 12:49:19 Kernel error: 0x62505. Date-time value "2013-09-27 10:47:32" is<br>
> invalid. Illegal symbol at "3" position.<br>
> This happens in my app and in Vstudio<br>
><br>
><br>
> It will work again temporarily if I go in to vstudio and change a flag on the<br>
> column (such as nullable). But once I exit Vstudio, the problem comes back in<br>
> my app that I'm building.<br>
<br>
<br>
</div>This means that DateFormat is different that you try.<br>
<br>
Please note, that about 3-4 years ago, we have made db engine to be more<br>
strict.<br>
<br>
Also was made that DateTime format is NOT saved into db file.<br>
This is because of VSERVER.<br>
<br>
Image that few clients around VSERVER want different formats.<br>
<br>
<br>
So. You need assign<br>
db.open<br>
db.DateTimeFormat = kYMD<br>
<br>
On each open/connect.<br>
<br>
Check this point please.<br>
<span class="HOEnZb"><font color="#888888"><br>
<br>
<br>
--<br>
Best regards,<br>
<br>
Ruslan Zasukhin<br>
VP Engineering and New Technology<br>
Paradigma Software, Inc<br>
<br>
Valentina - Joining Worlds of Information<br>
<a href="http://www.paradigmasoft.com/" target="_blank">http://www.paradigmasoft.com</a><br>
<br>
[I feel the need: the need for speed]<br>
</font></span><div class="HOEnZb"><div class="h5"><br>
<br>
_______________________________________________<br>
Valentina mailing list<br>
<a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><a href="http://www.bluewatermaritime.com/">http://www.bluewatermaritime.com</a>
</div>
_______________________________________________<br>Valentina mailing list<br><a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br>http://lists.macserve.net/mailman/listinfo/valentina<br></blockquote></div><br></div></div></body></html>