mysql int/date conversion

Greebo

N9017H - C172M (1976)
Joined
Feb 11, 2005
Messages
10,976
Location
Baltimore, MD
Display Name

Display name:
Retired Evil Overlord
Is there an easy way in mysql to convert an int value like 1160569782 to a date? I know that the int value is the # of seconds since a particular date (1/1/1970, I think), I can do the math using straight ansi sql but I was wondering if there's a built in mysql function I don't know about to ease the work?
 
Bah, wrong forum (moved it) and nevermind, found it - date_add - i'm used to T-SQL's DateAdd..
 
Back
Top