Search Results

Hi,

I tried using that, but getting the below error:

SQL0007N The character "\" following "select Date(" is not valid.
SQLSTATE=42601

Yes..we can subtract a date in database..but i want to use the variable i mentioned in the query..so i am unable to do $date_variable - 1 in my query as it gives a syntax error. For eg.

db2...

hi,

Thanks for the reply..but i cant include another script for just this purpose..is it possible to include the same logic in my script?
also note i need to use this date in an sql query..so...

No..I dont want yesterday's date ...it should be 1 day prior to the date stored in my variable...not sure if thats even possible or not..

Sorry for not mentioning it earlier..

OS: AIX, shell - ksh
Format: yyyy-mm-dd
Eg. 2015-01-29

Hi,

I have a variable which stores a date value in my script. let that be todays_date. This holds a date value which is based on some other calculation not relevant here.

I need the value of...