SELECT nvl(mfg_shelf_life, -1)
FROM dss.part_specs pspec
where mfg_shelf_life_timeframe in ('Y','W','M')
M - Months
Right now I do not have data with weeks.
I need to take that value and convert to days. Can I get a query to get these values?