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

Current day

P: 196
i would like to retreive data from a sql database only for the day its viewed on. Like now i would like all data to be displayed for today,when tomorrow comes, i would like to retreive all data for that day then. Not in a 24 hour period though
Jun 24 '09 #1
Share this Question
Share on Google+
2 Replies

code green
Expert 100+
P: 1,726
Why not use a date field entry ans simply match the date?
Jun 24 '09 #2

P: 196
dit figure it out <= convert(datetime,convert(varchar(12),getdate())). Thanx for the help tho
Jun 24 '09 #3

Post your reply

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