yanci1179
asked on
convert datetime
CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(),120), 120)
I am using the above to only get the date and exclude the time.
I get Jul 7 200
Is there a way that I can get 07/07/2006 instead?
I got this convertion from another question that I asked and just cut and paste, but can anyone walk me through with what its doing?
thanks!!
I am using the above to only get the date and exclude the time.
I get Jul 7 200
Is there a way that I can get 07/07/2006 instead?
I got this convertion from another question that I asked and just cut and paste, but can anyone walk me through with what its doing?
thanks!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER