#beginner sql question

11 messages · Page 1 of 1 (latest)

floral pelican
#

How many tracks were either downloaded before 6AM or after 10PM? need to right the code

sacred ermine
#

Can you share any more information?

#

What platform/service, what code do you have already, what's the data you're working with?

#

There's zero information about anything here right now

#

You'd have to have timestamps for the downloads, and write code to check that the timestamp is between 10pm and 6am

compact summit
#

Without more information like Hex is asking for it's hard. We don't know your table name or column names or the data type in those columns but probably something like this SELECT * FROM tracks WHERE download_time < 6 OR download_time > 22

floral pelican
#

SELECT *

FROM tblDownloads

where time >"6:00" or time <"22:00"

#

this is what I did and it just displays every time can you help?

sacred ermine
#

What's the SQL data you're trying to access?

#

Table/Row names?

sacred ermine
#

And time >"6:00" or time <"22:00" This will check if the time is larger than 6am, or smaller than 10pm