CONTENTS
xvii
7-6. Adding Hours, Minutes, Seconds, or Days to a Given Date....................................140
Problem ................................................................................................................................................ 140
Solution ................................................................................................................................................ 140
How It Works ........................................................................................................................................ 141
7-7. Returning the First Day of a Given Month ..............................................................142
Problem ................................................................................................................................................ 142
Solution ................................................................................................................................................ 142
How It Works ........................................................................................................................................ 143
7-8. Returning the Last Day of a Given Month...............................................................143
Problem ................................................................................................................................................ 143
Solution ................................................................................................................................................ 144
How It Works ........................................................................................................................................ 144
7-9. Rounding a Number ...............................................................................................144
Problem ................................................................................................................................................ 144
Solution ................................................................................................................................................ 144
How It Works ........................................................................................................................................ 145
7-10. Rounding a Datetime Value..................................................................................145
Problem ................................................................................................................................................ 145
Solution ................................................................................................................................................ 145
How It Works ........................................................................................................................................ 145
7-11. Tracking Time to a Millisecond ............................................................................146
Problem ................................................................................................................................................ 146
Solution ................................................................................................................................................ 146
How It Works ........................................................................................................................................ 147
7-12. Associating a Time Zone with a Date and Time ...................................................147
Problem ................................................................................................................................................ 147
Solution ................................................................................................................................................ 147
How It Works ........................................................................................................................................ 148