Viewing 2 posts - 1 through 2 (of 2 total)
UPDATE TBLSTORE SET COLOUMN2 = COLOUMN1
June 10, 2003 at 8:47 am
#460594
select convert(varchar(20), getdate(), 6)
will give u converted format ...
select convert(varchar(20), getdate()-1, 6)
will give u converted format with i day less as per ur reqmt...
happy programming
May 30, 2003 at 5:41 am
#459166
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy