Board index » delphi » TIMESTAMP Format

TIMESTAMP Format

Hi all!

I just want to check something!
Interbase is always using the format 'yyyy-mm-dd hh:mm:ss.zzz' for TIMESTAMP
fields by default?
I use IB 6.0.2

TIA!
Mario

 

Re:TIMESTAMP Format


In article <3dc65...@newsgroups.borland.com>, m.dam...@gantner.com
says...
Quote
> I use this timestamp field in a filter expression with a TADOQuery (after a
> select is performed),
> and i want to be sure that i make the correct formating.

        The correct way to do this is with a parameterized query.  Then
you don't need to worry about formatting at all.

        HTH,

        -Craig

--
 Craig Stuntz [TeamB] Vertex Systems Corp. Columbus, OH
     Delphi/InterBase Weblog: http://delphi.weblogs.com
     InterBase PLANalyzer (Free IB optimization tool):
          http://delphi.weblogs.com/IBPLANalyzer

Other Threads