<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>I store the exact date and time (in seconds). Just the day isn't sufficient for issues like syncing.</div><div><br></div><div>Jon</div><div><br></div><div><br></div><div><br></div><blockquote type="cite">That's what I do. Except I make YYYY-MM-DD be the date I use everywhere, including what I store in database as it is a much easier number to work with. It sorts correctly.<div><br></div><div><br><br><div class="gmail_quote">
On Sun, Jul 1, 2012 at 3:13 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 7/1/12 6:15 PM, "jda" <<a href="mailto:jda@his.com">jda@his.com</a>> wrote:<br>
<br>
HI<br>
<div class="im"><br>
> Ruslan,<br>
><br>
> Please read my posts again, carefully.<br>
><br>
> I do NOT use Valentina date and time fields,<br>
> I use my own fields (doubles)<br>
<br>
</div>Ok, but why by the way?<br>
What reason was ?<br>
<br>
DOUBLE is 8 bytes,<br>
Our DATE field is 4 bytes ...<br>
<div class="im"><br>
> and save the Mac date and time data.<br>
<br>
</div>You mean current date and time,<br>
Yes?<br>
<div class="im"><br>
> It works, and has for many years.<br>
<br>
</div>ok<br>
<div class="im"><br>
> I've been using an SQL search that let's me get records entered after a<br>
> relative date:<br>
><br>
> datediff( now(), '01/01/1904', 'seconds')<br>
<br>
> and it works for Engish! But the *stupid* function is language sensitive, so<br>
><br>
> '01.01.1904'<br>
><br>
> is required if the language is German.<br>
><br>
> And God knows what it is for Russian!<br>
<br>
</div>Jon,<br>
<br>
So problem is that when your app runs on German OS<br>
your hard-coded '01/01/1904' value becomes wrong?<br>
<br>
Well, fix is simple enough I think.<br>
<br>
You know that exists<br>
Vdatabase.DateTimeFormat,<br>
Vdatabase.DateSep<br>
Vdatabase.TimeSep<br>
<br>
So you can on start of your app assign that<br>
<br>
.format = kMDY<br>
.DateSep = '/'<br>
.TimeSep = ':'<br>
<br>
Now these settins will be used for any OS.<br>
And your hard-coded values will be valid<br>
<div class="im HOEnZb"><br>
<br>
> I want a simpler way to always get what I want without worrying about the<br>
> language.<br>
><br>
> If Valentina can't do this, just tell me.<br>
><br>
> Jon<br>
> Sonny Software<br>
<br>
<br>
</div><div class="HOEnZb"><div class="h5">--<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>
<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><br>
</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></body></html>