Yes this all works, that's no Problem if u use only TSQLDB.Even if you save the date time as string? I don't believe you :D. Now seriously you should use parameterised queries like this:
But if u use for example an SQL Admin Tool you cant read the Time or Dates !
So the Default Format is different.AFAIK there is no default format, but if everyone else use the Text format, you should also use it. In my previous example I made a small mistake, instead of:
Is there a way to set the default Format in TSQLDB ?
AFAIK there is no default format, but if everyone else use the Text format, you should also use it. In my previous example I made a small mistake, instead of:AFAIK there IS a default format. The default format (both in float as in integer) on Database level should always be yyyy/mm/dd since that corresponds to both possible binary representations and can easily compute.
AFAIK there IS a default format. The default format (both in float as in integer) on Database level should always be yyyy/mm/dd since that corresponds to both possible binary representations and can easily compute.Thaddy you're not grumpy, that's a relief. :D If I understood @ThMsmann correctly, he was looking for a setting in TSQLQuery where he can specify how the database engine should save the date time: as integer, as string or real. It's not the same thing. He's worried about the inconsistency between different tools(read above) and I agree with him.
I have Projects in Delphi, FreePascal, C++ and C and such inconsistency are very time consuming to find out. :-(I agree, this is annoying.
Thanks for your Help, and have a nice Day :-)You're welcome. Did you consider to switch to another database engine.
<grumpy >:D >Now that's the spirit! :D
Now that's the spirit! :DOh well... (<--- it's Friday and by Fleetwood Mac) Those quirks should not be there: database language theory is programming language neutral... Always has been...
OP is obviously not under-educated. As you can see, he writes program in c, c++, pascal etc..Just not familiar with the quirks of database programming in lazarus/freepascal.