Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change SQL Server 2005/Reporting services Datetime display format

Status
Not open for further replies.
JtheRipper

JtheRipper

IS-IT--Management
Oct 4, 2002
274
GB
Hi there,

I have a table in SQL Server with a datetime field. I got the data from Oracle using the import wizard. The data looks as follows in SQL Server:
2006-08-07 10:40:00.000
2006-08-07 10:45:01.000

How can I change this to display as:
10:40:00.000 2006-08-07
10:45:01.000 2006-08-07
In SQL Server and SQL Reporting services (2005)

In Oracle I can use the to_char function, but am having problems with SQL's cast/convert functions.

Any help will be much appreciated.

Thanks,
Jaco
 
Status
Not open for further replies.

Similar threads

MathiasB
  • Question
Parameterised sql server query
Replies
8
Views
342
Chriss Miller
C
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
753
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
926
pjw001
pjw001
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
575
Chris Miller
Chris Miller
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
518
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top