Member Avatar for freshfitz

How would I select everything from last month in a sql statment my cell has a time stamp in it

SELECT DateTimeStamp
from Get_estimates

Ouput

[DateTimeStamp]
2008-02-28 11:39:35.247
2008-03-09 13:15:12.513
2008-03-09 13:16:53.700
2008-03-26 13:30:20.077
2008-03-26 13:30:51.810

  • 2 Contributors
  • 4 Replies
  • 147 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by freshfitz

Recommended Answers

All 4 Replies

Member Avatar for Ramy Mahrous

So the output should be
2008-03-09 13:15:12.513
2008-03-09 13:16:53.700
2008-03-26 13:30:20.077
2008-03-26 13:30:51.810

right?

Member Avatar for freshfitz

I want to display all the orders from last month so

SELECT *
from Get_estimates
where DateTimeStamp = [lastmonth]
Member Avatar for Ramy Mahrous

Ok, please give me sample Data and your desired output

Member Avatar for freshfitz

I got it thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.