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