CODEWITHSUNDEEP
sqlfirebirdfirebird2.5
kuhajeyan
kuhajeyan

Reputation: 11017

how to get today date in YYYYMMDD in firebird

how to get today date in YYYYMMDD in firebird, I had a look on following but could not figured how to write this.

Upvotes: 3

Views: 43126

Answers (4)

Altivo
Altivo

Reputation: 488

IN FIREBIRD v2.5.5:

SELECT    LPAD( EXTRACT( YEAR FROM CURRENT_TIMESTAMP ), 4, '0' ) ||
          LPAD( EXTRACT( MONTH FROM CURRENT_TIMESTAMP ), 2, '0' ) ||
          LPAD( EXTRACT( DAY FROM CURRENT_TIMESTAMP ), 2, '0' ) || ' ' ||
          LPAD( EXTRACT( HOUR FROM CURRENT_TIMESTAMP ), 2, '0' ) ||
          LPAD( EXTRACT( MINUTE FROM CURRENT_TIMESTAMP ), 2, '0' ) || 
          LPAD( TRUNC( EXTRACT( SECOND FROM CURRENT_TIMESTAMP ) ), 2, '0' )
FROM      rdb$database

OUTPUT IS: YYYYMMDD HHMMSS

Upvotes: 6

Gordon Linoff
Gordon Linoff

Reputation: 1269983

I think you can do:

select replace(cast(cast('Now' as date) as varchar(10)), '-', '')
from rdb$database

Upvotes: 10

ASTERIAN75
ASTERIAN75

Reputation: 41

This is a fully version (in Integer)

select  Extract(year FROM cast('NOW' as date))*10000 +
        Extract(month FROM cast('NOW' as date))*100 +
        Extract(day  FROM cast('NOW' as date)) from rdb$database

This is a fully version (in VARCHAR)

select  CAST(Extract(year FROM cast('NOW' as date))*10000 +
        Extract(month FROM cast('NOW' as date))*100 +
        Extract(day  FROM cast('NOW' as date)) AS VARCHAR(8)) from rdb$database

Upvotes: 4

Ashish Ratan
Ashish Ratan

Reputation: 2870

This Should work.

CREATE TABLE tab( t time, d date, ts timestamp );
INSERT INTO tab(t,d,ts) VALUES ('14:59:23', '2007-12-31', '2007-12-31 14:59');

SELECT CAST(CAST(d as varchar(10)))
FROM tab;

Upvotes: 2

Related Questions