tag:blogger.com,1999:blog-6082652835152798567.post85464732993425376..comments2024-03-28T21:41:58.974-07:00Comments on Sql server, .net and c# video tutorial: DateTime functions in SQL Server - Part 25Unknownnoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-6082652835152798567.post-80965859805675638502021-05-18T22:29:49.337-07:002021-05-18T22:29:49.337-07:00how can I get india time how can I get india time Anonymoushttps://www.blogger.com/profile/16200272248659528149noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-26242791536147309182015-06-06T13:51:44.262-07:002015-06-06T13:51:44.262-07:00Hi Venkat,
your videos are amazing , I am using SS...Hi Venkat,<br />your videos are amazing , I am using SSMS 2005 and I can't create a column with data_type of [time] or [Date] <br />the only available option is [Dateandtime]<br />I don't know, but is there's something wrong with the program or with my code.?<br />Thank you.Mended_Hearthttps://www.blogger.com/profile/06306495324783598191noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-18603198396268926332014-07-21T11:14:37.097-07:002014-07-21T11:14:37.097-07:00Hi Nisar,
This was new to me too!! but if you put...Hi Nisar,<br /><br />This was new to me too!! but if you put the DToffset value within '' then it will work. I tried without '' just as you did and it gives me an error. Hope it helps others who are viewing this page.. <br /><br />update tblDateTime set c_datetimeoffset = '2014-07-22 13:37:27.8430000 +10:00'<br />where c_datetimeoffset = '2014-07-21 14:09:38.2930000 +00:00'Anonymoushttps://www.blogger.com/profile/08816282653218110283noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-54520568992759253432014-05-12T13:55:45.193-07:002014-05-12T13:55:45.193-07:00update tblDateTime set c_datetimeoffset = 2014-05-...update tblDateTime set c_datetimeoffset = 2014-05-12 13:37:27.8430000 +10:00<br />where c_datetimeoffset=2014-05-12 13:37:27.8430000 +00:00<br /><br />this query throw the following error to me..... <br />Msg 102, Level 15, State 1, Line 1<br />Incorrect syntax near '13'.Nisar Ahmadhttps://www.blogger.com/profile/07589799751051926861noreply@blogger.com