Jump to content

Fetch Date From Table


Ajmal
 Share

Recommended Posts

Hi. I have the Database table in which i set the date column also and now i want to fetch all the data order by Date.How to fetch data from database in order by Insertion Date and Time using mySql query.Thanks for your time.

Link to comment
Share on other sites

Using the ORDER BY clause. http://www.w3schools.com/sql/sql_orderby.aspYou can have multiple ordering field, so if your date and time (for some reason) were stored in different fields you could do

... ORDER BY date, time

Link to comment
Share on other sites

Using the ORDER BY clause. http://www.w3schools.com/sql/sql_orderby.aspYou can have multiple ordering field, so if your date and time (for some reason) were stored in different fields you could do
... ORDER BY date, time

Thanks Dear.But please tell me that how to fetch only the current month records. Means Fetch only one month records.
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...