SQL Date Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

This is in regards to SQL date format. In Oracle, you can use the
To_Char(DateField, 'Month-dd-yyyy') to format the result on your date field.

2006-09-20 00:00:00 = Sept-20-2006

What is the function in SQL2K?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Format Question Again 2
Date format when exporting 2
Date formatting problem on some PCs 2
Pivot table macro filter data between yesterday and today (date+time) 0
Computing minutes, days and years 3
Converting date from an external source 1
Date format 4
Changing Data format 3

Back
Top