sql commands for datediff
in [Programming SQL]
|
Prev: Is there any function to convert the first letter to upper case?
Next: Apply a calculation to all values in a column?
From: ayis on 13 Jan 2010 00:10 hi i need a sql query for finding the datediff for a week,my problems is i have to automatic send a mail to hr by checking who are the staff coming late more than two days in a week,the mail has to be send last working day of that week. Submitted via EggHeadCafe - Software Developer Portal of Choice Word HTML Cleaner http://www.eggheadcafe.com/tutorials/aspnet/32f02d6f-2118-4517-ba64-8d998c6afa42/word-html-cleaner.aspx
From: Uri Dimant on 13 Jan 2010 05:55
Hi In such sitautions I would perefer having a calendar table contains working days, vacations and etc... and compate against that table <ayis sath> wrote in message news:201011301016ayishjailu(a)yahoo.co.in... > hi i need a sql query for finding the datediff for a week,my problems is i > have to automatic send a mail to hr by checking who are the staff coming > late more than two days in a week,the mail has to be send last working day > of that week. > > > Submitted via EggHeadCafe - Software Developer Portal of Choice > Word HTML Cleaner > http://www.eggheadcafe.com/tutorials/aspnet/32f02d6f-2118-4517-ba64-8d998c6afa42/word-html-cleaner.aspx |