how to get yydddsssssmmmm format from Current Data base Timestamp in DB2
Posted on 2004-09-02
My requirement is to generate unique sequence number with the following format
yy = year
ddd = julian date
sssss = current seconds
mmmm = milliseconds
I am able to do first 2 things. How about the rest.
I appreciate your ideas!!!