View Single Post
Join Date: Sep 2008
Posts: 339
Reputation: freshfitz is an unknown quantity at this point 
Solved Threads: 27
freshfitz freshfitz is offline Offline
Posting Whiz

Get last month from timestamp

 
0
  #1
Jan 1st, 2009
How would I select everything from last month in a sql statment my cell has a time stamp in it

  1. SELECT DateTimeStamp
  2. 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
Last edited by freshfitz; Jan 1st, 2009 at 3:50 pm.
Reply With Quote