Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lsy
Yak Posting Veteran
57 Posts |
 Posted - 2006-10-16 : 03:41:42
|
| How to get seconds between 2 date?? i have try using DateDiff function but it seem not working in MS Access.My statement as SELECT DATEDIFF(SECOND, START_DATE, END_DATE) FROM TABLEbut it return error... any idea?? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-16 : 03:43:14
|
| select datediff("s", start_date, end_date)HELP FILE is your friend.Peter LarssonHelsingborg, Sweden |
 |
|
|
lsy
Yak Posting Veteran
57 Posts |
Posted - 2006-10-16 : 03:46:55
|
| really thanks a lots...i follow the sql syntax... no wonder!! |
|
|
|
|
|
|
different between 2 date..