Subject | date in ccyymmdd format inside procedure |
---|---|
Author | Rick Roen |
Post date | 2008-11-13T14:49:53Z |
FB 2.1
I see in Helen's book on page 144 there are date literals that I can
use in an Extract statement, but I don't know how.
Inside a procedure, I would like to take a date value and convert to a
string like "CCYYMMDD", i.e. "20081101". I know I can pull the date
apart with Extract and then pad the single digit month and day values,
but is there a better way?
Rick
I see in Helen's book on page 144 there are date literals that I can
use in an Extract statement, but I don't know how.
Inside a procedure, I would like to take a date value and convert to a
string like "CCYYMMDD", i.e. "20081101". I know I can pull the date
apart with Extract and then pad the single digit month and day values,
but is there a better way?
Rick