Problem with datetime - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Problem with datetime

Author

Topic

rowjie
Starting Member

2 Posts

Posted - 2006-06-13 : 05:59:49

Good day!

I am currently doing a module where I should be able to generate reports.

I have a schedule table and an appointments table.

Upon combining the two tables, I should be able to produce:
1) Available and Unavailable schedules
2) Available schedules only
3) and Unavailable Schedules

Please help me because I am havong problem regarding the datatype datetime
I need to finish this before friday.

Thanks!

RyanRandall
Master Smack Fu Yak Hacker

1074 Posts

Posted - 2006-06-13 : 07:00:44

quote:
I am havong problem regarding the datatype datetime

Hi rowjie,

This article might help you understand the datetime datatype...

http://www.sql-server-performance.com/fk_datetime.asp

Ryan Randall
www.monsoonmalabar.com London-based IT consultancy

Solutions are easy. Understanding the problem, now, that's the hard part.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources