Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 select data

Author  Topic 

jafrywilson
Constraint Violating Yak Guru

379 Posts

Posted - 2010-10-15 : 10:03:14
Hi..
How to select today record using date..My table contains date with the tiime like'15/10/2010 12.00.00'
I tried using getdate() but it won't work what is the reason for this problem..

I need to select every one hour and update to another table...
help me!!!

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-10-15 : 10:42:19
jafrywilson with 316 Post (6 Posts per Day).
It is amazing how resistant you are against our request to ask your questions more clear.

Is it possible for you to give us table structure(s), sample data and wanted result?

You know that we are always willing to help you but you should be willing to make our part as easy as possible.

Best regards
webfred


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2010-10-15 : 11:17:15
quote:
Originally posted by jafrywilson

<snip>I need to select every one hour and update to another table...
help me!!!

This is the best I can do with the information provided:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page
   

- Advertisement -