Re: Converting epoch times after 2038


XP is just a number
	PerlMonks

Re: Converting epoch times after 2038

by Moron (Curate)

on Apr 05, 2007 at 12:32 UTC ( [id://608466]=note: print w/replies, xml )

Need Help??

in reply to Converting epoch times after 2038

If this is the XY problem I think it is, you could get Sybase to split the dateparts for you in advance using the Transact-SQL datepart function, e.g.:

SELECT datepart(yy,attr_val),
       datepart(mm,attr_val),
       datepart(dd,attr_val)
FROM date_attribute_values
WHERE instrument_id = 12345
AND attr_id = 'MATURITY'
[download]

-M

Free your mind