Help manipulating date/time from SQL server

[scrupul0us]

I am needing to format a timestamp returned from a SQL database.

When displayed directly its in a format like this:

7/31/2008 1:34:00 PM

What I would like is:

07/31/08 01:34

Thanks

[Brandoe85]

Check out the date formats:
http://msdn.microsoft.com/en-us/library/ms187928.aspx

[scrupul0us]

thanks Brandoe85... I had already actually been there but the MSDN site lacks examples and I'm just not familiar enough with those types of sql queries to pick it up blindly