Firebird Select Field From Table where Field = current_date

Question

I have a simply but fror me unsolveable question

I have this request:

The problem is that this field is a text field an holds date in this format: 25.04.2014

How can i convert it that this questions works if it is the current date.

If possible, take the time to convert this field to an actual `DATE` field. — Mark Rotteveel, Apr 18 '14 at 06:54
possible duplicate of [Select Varchar as Date](http://stackoverflow.com/questions/23846292/select-varchar-as-date) — Mark Rotteveel, Sep 27 '14 at 07:38

score 4 · Answer 1 · answered Apr 18 '14 at 01:22

4

SELECT fields FROM table WHERE field=
  substring(100+extract(day from current_date) from 2 for 2)
  || '.' ||
  substring(100+extract(month from current_date) from 2 for 2)
  || '.' ||
  extract(year from current_date)

answered Apr 18 '14 at 01:22

Eugen Rieck

64,175
10
70
92

One more: I would like to delete all found current dates in that field after this select how could i do this? – Michael Müller Apr 18 '14 at 17:21
`DELETE FROM table WHERE field= ...` – Eugen Rieck Apr 18 '14 at 17:54

Firebird Select Field From Table where Field = current_date

1 Answers1

Linked