Thanks, thats better than substring.

2012/5/16 Huan Ruan <leohuanruan@...>:

> Hi
>
>  Hi everybody,
>>
>> There is a way to format a datetime inside a query ?
>>
>> When use a CAST function to convert datetime to string :
>>
>> CAST(SUBSTRING(CAST(a.LAST_UPDATE as varchar(30)) FROM 1 FOR 10) <-
>> Get only date, without a time.
>>
>> From this cast, returning date in format YYYY-MM-DD, but I would like
>> to see DD-MM-YYYY for concatenate purpose.
>> Of curse that I can use SUBSTRING to get day, month and year
>> separately, but its too long to be written.
>>
>
> There is no function in Firebird to directly format a date. However, there
> is a better way in SQL to get each component out of a date (e.g. day,
> month, year, etc) than SUBSTRING. It's EXTRACT. e.g.
>
> select
>  extract(year from current_date) || '-' ||
>  lpad(extract(month from current_date), 2, '0') || '-' ||
>  extract(day from current_date)
> from rdb$database
>
> Note, the 'lpad' is only needed if you want to display May as '05' instead
> of '5'.
>
> Cheers
> Huan
>
>>
>>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu.  Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>