troubleshooting Question

SQL QUERY

Avatar of RIAS
RIASFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL ServerMicrosoft SQL Server 2008
3 Comments1 Solution158 ViewsLast Modified:
Hello,
How can i write a query to check if data is not entered in the table for past 15 days.
TableA
Field : start_time (datatype nvarchar)

The field start_time has data like which has the current date an time  :
2013-08-06T06:18:10Z
2013-11-18T10:22:12Z
2013-11-27T12:56:18Z
2013-11-28T07:33:41Z
2013-11-28T07:42:31Z
2013-11-28T07:47:41Z
2013-11-28T07:49:41Z
2013-11-28T19:01:52Z
2014-12-09T08:47:17Z
2014-12-09T08:49:07Z
2014-12-09T08:51:07Z
2014-12-10T07:48:38Z
2014-12-10T08:03:08Z
2014-12-11T13:03:01Z
2014-12-11T13:11:17Z
2014-12-17T15:24:41Z

Cheers
ASKER CERTIFIED SOLUTION
Vitor Montalvão
IT Engineer
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros