Custom SQL DateTime format

Question

The European format of dd/mm/yy hh:mm isn't supported by SQL, is there any way to create one? I am trying to return it in a stored procedure like so:

ALTER PROCEDURE dbo.GetMeetingByCustomerID
    @CustomerID nvarchar(50),

AS

    SELECT  ProfessionalID, MeetingDate, Cost, HasReview, Approved
    FROM     Meeting
    WHERE  (CostumerID = @CostumerID)
    ORDER BY MeetingDate ASC
    RETURN

The only problem is that it returns it in the wrong format. Is there a way to create a new one? Thanks. EDIT: I solved this. what I did was:

 MeetingDate = DateTime.Parse(Meetings.Tables[0].Rows[i][1].ToString());
                string d = MeetingDate.ToString("hh:mm dd/MM/yy");

Why do it in SQL? Do it in the application. What version of SQL Server (I am assuming that's what you are using)? — Oded
– Oded, Commented Mar 27, 2013 at 21:28
Agree with Oded. Return an actual date, and format it in the application. — Robert Harvey
– Robert Harvey, Commented Mar 27, 2013 at 21:29
Most db's have date formatting functions. Knowing the db engine you are using would help find them. — Dan Bracuk
– Dan Bracuk, Commented Mar 27, 2013 at 21:30
Formatting a date is responsability of the application that gets the date back from your query, unless you try to return a character strings instead of a date — Steve
– Steve, Commented Mar 27, 2013 at 21:31

Alex Klaus · Accepted Answer · 2013-03-28 05:41:56Z

1

First of all, I believe it's incorrect to format date/time in SELECT requests. But if you really need it, use CAST/CONVERT (if you use MS SQL) and remove unused symbols like:

SELECT ProfessionalID, CONVERT (varchar(5), MeetingDate, 108) AS MeetingDateString, Cost, HasReview, Approved
FROM     Meeting
WHERE  (CostumerID = @CostumerID)
ORDER BY MeetingDate ASC

edited Mar 28, 2013 at 5:41

answered Mar 27, 2013 at 21:36

Alex Klaus

9,0949 gold badges77 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Michael Sallmen Over a year ago

You'll want to alias the result of the CONVERT.

Htusa Adssad Over a year ago

How can I do it in the application? im using c# and asp.net

Alex Klaus Over a year ago

@MichaelSallmen, yes sure, an alias should be there. I fixed my answer. Htusa, formating depends on the control type you're going represent this information in. I'd recommend to go to msdn.microsoft.com/en-us/library/8kb3ddd4.aspx to get general information on formatting date/time in C#

Collectives™ on Stack Overflow

Custom SQL DateTime format

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related