/****** Script for SelectTopNRows command from SSMS ******/
update transactions set timeEntry= CAST('2015-02-02 09:00:00.000' as datetime)
FROM [Retcom].[dbo].[transactions] where trxNo='4256'
Perhatian: Yuk Baca Artikel bagus di Nurul Musthofa
Sunday, 9 August 2015
Merubah datetime di sql server 2008
berikut adalah script di sql server 2008 untuk merubah tanggal di date time .
/****** Script for SelectTopNRows command from SSMS ******/
update transactions set timeEntry= CAST('2015-02-02 09:00:00.000' as datetime)
FROM [Retcom].[dbo].[transactions] where trxNo='4256'
Perhatian: Yuk Baca Artikel bagus di Nurul Musthofa
/****** Script for SelectTopNRows command from SSMS ******/
update transactions set timeEntry= CAST('2015-02-02 09:00:00.000' as datetime)
FROM [Retcom].[dbo].[transactions] where trxNo='4256'
Perhatian: Yuk Baca Artikel bagus di Nurul Musthofa
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment