insert date

Please support our MS SQL advertiser: Intel Parallel Studio Home
Reply

Join Date: Nov 2009
Posts: 1
Reputation: pavankotturi is an unknown quantity at this point 
Solved Threads: 0
pavankotturi pavankotturi is offline Offline
Newbie Poster

insert date

 
0
  #1
32 Days Ago
how to insert system current date by using sql query in SQL SERVER 2005
Reply With Quote Quick reply to this message  
Join Date: Dec 2007
Posts: 113
Reputation: abhi_elementx is an unknown quantity at this point 
Solved Threads: 6
abhi_elementx's Avatar
abhi_elementx abhi_elementx is offline Offline
Junior Poster
 
0
  #2
32 Days Ago
Originally Posted by pavankotturi View Post
how to insert system current date by using sql query in SQL SERVER 2005
use getdate() function : insert into tab_name values(getdate())
PEACE !
Reply With Quote Quick reply to this message  
Reply

Tags
sqlserver

Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC