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!
-
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!
Date with format d/m/yyyy
- Thread starter simma
- Start date
- Thread starter
- #3
I see.... try this one.
select convert(varchar(20), datefield, 103)
Andel
andel@barroga.net
select convert(varchar(20), datefield, 103)
Andel
andel@barroga.net
- Thread starter
- #5
how about this?
select convert(varchar(5), day(getdate())) + '/' + convert(varchar(5), month(getdate())) + '/' + convert(varchar(5), year(getdate()))
Andel
andel@barroga.net
select convert(varchar(5), day(getdate())) + '/' + convert(varchar(5), month(getdate())) + '/' + convert(varchar(5), year(getdate()))
Andel
andel@barroga.net
- Thread starter
- #7
Just for what it's worth. Dates in SQL server datetime or smalldatetime format don't *have* an inherent md or dm order or format. So it's all in how you display it.
Have you checked out the setting in your database,
SET DATEFORMAT
?
-------------------------------------
It is better to have honor than a good reputation.
(Reputation is what other people think about you. Honor is what you know about yourself.)
Have you checked out the setting in your database,
SET DATEFORMAT
?
-------------------------------------
It is better to have honor than a good reputation.
(Reputation is what other people think about you. Honor is what you know about yourself.)
- Status
Similar threads
- Locked
- Question