| Subject | Date problem in Firebird |
|---|---|
| Author | shaamim_ply |
| Post date | 2005-06-09T13:45:52Z |
Hi
i have a problem in select query.
When i issue the following select query
"select DT_START,DT_END,DT_START || ' - ' || DT_END SHAM from
year_setup"
iam getting the following result
dt_satrt=01.04.2005
dt_end=31.03.2006
SHAM=2005.04.01 - 2006.03.31
(* Dates are stored in dd.mm.yyyy format in the year_setup table)
But i want to get the third field in the same format as the first two.
How can i do?
i have a problem in select query.
When i issue the following select query
"select DT_START,DT_END,DT_START || ' - ' || DT_END SHAM from
year_setup"
iam getting the following result
dt_satrt=01.04.2005
dt_end=31.03.2006
SHAM=2005.04.01 - 2006.03.31
(* Dates are stored in dd.mm.yyyy format in the year_setup table)
But i want to get the third field in the same format as the first two.
How can i do?