Click here to Skip to main content
12,063,006 members (31,858 online)
Rate this:
 
Please Sign up or sign in to vote.
I use the datetime in table, but in my procedure I use varchar.

I convert varchar to datetime like...
CONVERT(DATETIME, 2013/02/20,103)
.
This is not giving problem on my server, but on other server query gives problem.

Please find solution.
Posted 21-Mar-13 21:20pm
v2
Comments
phil.o 22-Mar-13 3:40am
   
"I use the datetime in table, but in my procedure I use varchar."

Why ?
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Hi Try this...

SET DATEFORMAT dmy
SELECT '22/02/2013'
 
SET DATEFORMAT mdy
SELECT '03/22/2013'
 
SET DATEFORMAT ymd
SELECT '2013/03/22'
 
-- Detault format is "mdy"

Check the following link...

SET DATEFORMAT (Transact-SQL)[^]
Regards
GVPrabu
  Permalink  
v2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Try this:
CONVERT(DATETIME, '2013/02/20',103)
or
DECLARE @myDate VARCHAR(10)
 
SET @myDate = '2013/03/20'
CONVERT(DATETIME, @myDate,103)

Do you see the difference?
  Permalink  

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web04 | 2.8.160204.4 | Last Updated 22 Mar 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100