Solved

SQL select

Posted on 2014-03-20
3
298 Views
Last Modified: 2014-03-20
Hi Experts,

I have table where one column is timestamp type. I need to get rows comparing date part only of timestamp to mine 'YYYY-MM-DD'

Thanks.
0
Comment
Question by:fpoyavo
3 Comments
 
LVL 65

Expert Comment

by:Jim Horn
ID: 39942696
Give us a 'for example..' of what you're trying to pull off here.

SQL expert PortletPaul has an excellent article on SQL Server Date Styles using CONVERT(), where your answer will likely be in there somewhere.
0
 
LVL 1

Author Comment

by:fpoyavo
ID: 39943082
Hi Jim,

I tried this WHERE convert(varchar, my_tmsp ,110) = '03-20-2014'
 
and it does not work ... empty result

Thanks.
0
 
LVL 11

Accepted Solution

by:
John_Vidmar earned 500 total points
ID: 39943252
SQL Server's TIMESTAMP data-type has nothing to do with a date and/or time, it's just a binary representation of a consecutive number - it's only good for making sure a row hasn't change since it's been read.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Help 27 57
Complex Query - help please 5 52
Amazon RDS migrate to SQL Server 3 26
SQL Server Shrink hurting performance? 4 21
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

838 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question