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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

select

Status
Not open for further replies.
mayu03

mayu03

Programmer
Oct 3, 2003
91
US
What is incorrect in this select?
select Format('01/01/04','yyyymmdd')
 
Sort by date Sort by votes
the main thing that's wrong is that there is no such function in sql server

and assuming there were, it is not guaranteed that the first parameter will be interpreted as a datetime value, rather than as a character string

rudy
SQL Consulting
 
Upvote 0 Downvote
Can you tell me what function should I use?
 
Upvote 0 Downvote
is this ok ?

PRINT Convert(Char(20), getdate(), 120)
PRINT Convert(Char(20), getdate(), 111)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
280
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
167
grnzbra
grnzbra
Auguy
  • Locked
  • Question
Using UDF In Select, Bad Idea? 2
Replies
3
Views
149
Auguy
Auguy
grnzbra
  • Locked
  • Question
Is "IF EXISTS()..." better than "IF (SELECT COUNT...) > 0"
Replies
4
Views
1K
gmmastros
gmmastros
TheBugSlayer
  • Locked
  • Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks 2
Replies
10
Views
337
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top