var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Working with Sybase Dates
I was wondering if you could help me.
I am currently working with Sybase.
The dates within the Sybase tables are specified as YYYYMMDD e.g. 20020326.
If todays date was 20020326, I would like to know what the exact date is 9 months ago.
How can I go about finding this ?
I would be most grateful if you could let me know.
Thanks in advance
I managed the solve the Sybase Dates problem (previous email)
This is how I did it:
(select convert(numeric(8,0), (select convert(varchar(8), dateadd(month,-9,'20020326'), 112))))