August 30, 2008 03:26am pdt

1. chapmandew 2,035,326
2. angelIII 1,369,238
3. aneeshatti... 513,981
4. mark_wills 473,116
5. ee_rlee 313,995
6. brejk 226,005
7. dtodd 209,505
8. momi_sa... 177,049
9. acperkins 173,863
10. rickchild 167,940
11. ptjcb 160,219
12. Thomasian 155,142
13. EugeneZ 143,750
14. BrandonG... 143,655
15. sbagireddi 136,982
16. dportas 125,215
17. ScottPletc... 123,615
18. jgv 115,921
19. appari 114,604
20. PFrog 113,160
21. DanielWilson 106,114
22. chrismc 105,889
23. PedroCGD 104,345
24. tedbilly 103,765
25. bashka_... 98,724

1. angelIII 2,649,429
2. chapmandew 2,035,326
3. aneeshatti... 1,079,086
4. ptjcb 525,611
5. Yveau 517,373
6. mark_wills 473,116
7. dtodd 420,510
8. PFrog 383,188
9. dqmq 368,078
10. appari 350,751
11. imitchie 333,350
12. ee_rlee 313,995
13. acperkins 269,202
14. ScottPletc... 227,282
15. brejk 226,005
16. Lowfatsp... 223,289
17. matthews... 203,352
18. rboyd56 196,590
19. SQL_SE... 190,215
20. EugeneZ 180,459
21. momi_sa... 178,749
22. gbshahaq 177,810
23. tedbilly 172,104
24. DanielWilson 171,904
25. dportas 169,180

05.09.2008 at 05:06PM PDT, ID: 23391100

	[x] Attachment Details

SQL DateTime Function

Asked by DylanJones1 in SQL Server 2005, MS SQL Server, SQL Query Syntax

Can someone tell me what the purpose of the following function might be: I came across it in an older stored proc. Really what I am wondering is the effect of the "1440" - it seems its just returning a days worth of minutes when the start and end datetimes are equal. By the way the data is hours -
I.E.
StartDate 1:45
End Date 2:30

ThanksStart Free Trial

Keywords: SQL DateTime Function

	Title
1	Converting varchar to a Datetime
2	SQL datetime issue
3	SQL and DateTime calculations
4	How to check for null value of DateTim…
5	convert datetime to varchar
6	SQL Reporting Services - Supply valu…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

SQL DateTime Function

Asked by DylanJones1 in SQL Server 2005, MS SQL Server, SQL Query Syntax

About this solution