Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Trim time from date

May 26, 2003, 10:09 AM
ArmyAirForces
Veteran (1104 posts)
May 26, 2003, 10:09 AM
Post #1 of 1
Views: 4738
Shortcut
Quote Reply
Trim time from date
I want to add "latest_reply_short" to this stored procedure that trims off the time, showing only the date.



select dbo.stringfromunixdate(2000000000 - post_latest_reply) as latest_reply



Help?

Last edited by:

ArmyAirForces: May 26, 2003, 10:10 AM