Date Between Format

[Former Member]

Hi ,

wana know what should be the format in DB2 to dates , i used following its giving error

DTE  Between  '2014-04-18' ; '2014-04-21'

[hugo_amo · Accepted solution]

Hi Usman,

Have a look at these links:

IBM Knowledge Center

IBM Knowledge Center

Hope it helps.

Regards,

Hugo

[Former Member · Accepted solution]

i need to know whats wrong with my syntax , do i need to put Brackets or comma instead of semi-coln, etc

[KayKa · Accepted solution]

Hi Usman,

try an AND instead of the semicolon.
regards
Kay

[Former Member · Accepted solution]

Worked !

Thanks !