Board index » delphi » interbase timestamp format

interbase timestamp format

Select

 (Extract(Day From Abs.dtup) || Extract(Month From Abs.dtup) || Extract(Year
From Abs.dtup)),

From Abs
Group By  (Extract(Day From Abs.dtup) || Extract(Month From Abs.dtup) ||
Extract(Year rom Abs.dtup))
Order By  (Extract(Day From Abs.dtup) || Extract(Month From Abs.dtup) ||
Extract(Year rom Abs.dtup))

    This select will be result the date like this

    112001
    212001
    312001

    How i implement SQL to result like this

    01012001
    02012001
    03012001

    Completing numbers with 0... like 2 digits to month, day and 4 to year.

    Thanx all

 

Re:interbase timestamp format


Quote
Cristian wrote:

> Select

        Multi-posted.  Please do not multi-post.  I answered this question the
first place you posted it.

        -Craig

--
 Craig Stuntz (TeamB) Vertex Systems Corp. Columbus, OH
We're hiring: http://www.vertexsoftware.com/careerops.htm#sd
     Delphi/InterBase WebLog: http://delphi.weblogs.com

Other Threads