August 29, 2008 02:35pm pdt

1. chapmandew 119,418
2. mark_wills 70,125
3. angelIII 67,670
4. ee_rlee 38,140
5. momi_sa... 19,955
6. aneeshatti... 17,000
7. BrandonG... 15,750
8. dportas 14,890
9. acperkins 12,614
10. Thomasian 12,000
11. ScottPletc... 11,800
12. slam69 8,800
13. brejk 7,820
14. dtodd 7,700
15. bashka_... 7,475
16. rickchild 7,200
17. emoreau 7,160
18. appari 6,800
19. EugeneZ 6,150
20. jgv 6,000
21. SteveH_UK 5,500
22. ptjcb 5,200
23. Binuth 5,000
23. Yveau 5,000
25. paulop1... 4,900

1. chapmandew 119,418
2. mark_wills 70,125
3. angelIII 67,670
4. ee_rlee 38,140
5. Yveau 33,340
6. aneeshatti... 21,560
7. momi_sa... 19,955
8. BrandonG... 15,750
9. dportas 14,890
10. acperkins 13,814
11. Thomasian 12,000
12. ScottPletc... 11,800
13. appari 8,800
13. slam69 8,800
15. ptjcb 8,200
16. brejk 7,820
17. dtodd 7,700
18. bashka_... 7,475
19. emoreau 7,260
20. rickchild 7,200
21. nmcdermaid 6,700
22. EugeneZ 6,150
23. jgv 6,000
24. SteveH_UK 5,500
25. Binuth 5,000

06.16.2008 at 01:14PM PDT, ID: 23489504

	[x] Attachment Details

Out-of-range datetime value

Asked by pigmentarts in SQL Server 2008, SQL Server 2005

<cfset datepassed = #DATEFORMAT(now(), "dd/mm/yy")#>

SELECT CONVERT(VARCHAR(10), TIMEDATE , 120) as varDate
FROM orders
WHERE YEAR(TIMEDATE) = YEAR('#datepassed#')
AND MONTH(TIMEDATE) = MONTH('#datepassed#')
AND DAY(TIMEDATE) = DAY('#datepassed#')

ERROR:

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.Start Free Trial

Keywords: Out-of-range datetime value

	Title
1	Converting varchar to a Datetime
2	ColdFusion DateFormat Function Result…
3	datetime transtypage in SQL SERVER
4	convert datetime to varchar
5	Converting datetime problem
6	MySQL DATETIME

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_EXPERT_20070906

Out-of-range datetime value

Asked by pigmentarts in SQL Server 2008, SQL Server 2005

About this solution