General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Brow with time field
Dear Experts
Table1 has three fields as
date d(8)
time c(8)
amount n(2)
and data in table is as
---date--------time---amount
05-10-07---15:35:55----50
05-10-07---20:35:55----65
06-10-07---05:35:55----70
06-10-07---07:35:55----10
06-10-07---12:35:55----40
I want to brows data with following time codition
From previous date 20:00:00 to Today 08:00:00
Suppose today is 06-10-07 then these recourds must brows
05-10-07---20:35:55----65
06-10-07---05:35:55----70
06-10-07---07:35:55----10
Please help
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only