How can I change date format in join query?

Question

0.00/5 (No votes)

See more:

Hi dears,

I have this join query:

SQL

Select Users.UserName, Attendence.TimeIn, Attendence.TimeOut from Users Inner Join  Attendence on Users.UserID = Attendence.UserID

Where TimeIn and TimeOut are date columns and their date format is dd/mm/yy. Please tell me how can I change my date format in this join query when retrieving these records from database. I want to show this in format dd-mm-yy. Please guide.

Posted 18-May-10 22:01pm

touseef4pk

Updated 18-May-10 23:30pm

Sandeep Mewara

v3

Add a Solution

4 solutions

Solution 4

thanks all you dears for your kind help.

Posted 19-May-10 21:01pm

touseef4pk

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2010-05-18T23:29:00

You can use CONVERT:
Here you go...
CAST and CONVERT[^]
How to format a Date or DateTime in SQL Server[^]

Thus, you can change format of the date in SQL as below:

SQL

SELECT CONVERT(nvarchar(30),GETDATE(),101) AS MyCustomServerDate

Out here change the 3rd parameter value from 100-114, you can get different formats.

hiren soni · Accepted Answer · 2010-05-19T00:50:00

you can change format like this

Select Users.UserName, convert(varchar,Attendence.TimeIn,105) as TimeIn, convert(varchar,Attendence.TimeOut,105) as TimeOut from Users Inner Join  Attendence on Users.UserID = Attendence.UserID

and you want just dd-mm-yy instead of dd-mm-yyyy then write just 5 instead of 105

vipsha · Accepted Answer · 2010-05-19T01:19:00

Solution 3

hi friend,

Just try this for date, you will get 100% result

SELECT CONVERT(nvarchar(50),GETDATE(),101) from [Table_name]

insted of 101 you can choose different value upto 100-114.

Biji taklif hoy to amne seva no labh aapjo.

thanks,
mahesh patel(vipsha)

Posted 19-May-10 1:19am

vipsha

Updated 19-May-10 1:20am

v2

How can I change date format in join query?

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0