I have a query in sql server that returns the following
The table these data fields come from is a local temp table
The data itself comes from an OPENQUERY to an Oracle database
My question is,
I would like the date time to be presented as for example
Jan 14 2011 14.00
Jan 14 2011 2:00PM
Is there some data type i can declare in the temp table that will produce this format?