By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,655 Members | 1,875 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,655 IT Pros & Developers. It's quick & easy.

Query to select record between evening 6 pm to morning 6 am

P: 2
I have table in which Shift no, Start time. End time. if start time of shift is 6pm and end time of shift is 6 am then I want to select record between start time and end time.I need query to selct such record.
Jul 18 '07 #1
Share this Question
Share on Google+
2 Replies


P: 16
You need to provide your table structure. Very difficult writing a query without knowing table and field names and whether the time and date fields are separate or merged.

Cheers
Jul 18 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
I have table in which Shift no, Start time. End time. if start time of shift is 6pm and end time of shift is 6 am then I want to select record between start time and end time.I need query to selct such record.
Also are the Start time and End time fields a timestamp. i.e. do they contain the date as well as the time.

You need to give a lot more information on the structure of your records and what values are being stored.
Jul 18 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.