javascript - 12AM time lost/not displaying in mapping interface -
the time values being displayed in our arcgis api javascript mapping service correctly except midnight 12am (it not display time, date). displaying datetime1 field in our mapping service. displaying est.
the polygons stored in sql server table. in our sql server datetime1 field midnight 1/1/13 contain:
2013-01-01 00:00:00.0000000
and 1 a.m:
2013-01-01 01:00:00.0000000
i'm not entirely sure begin. javascript issue or need store times differently in sql server? thank you. new current job , have inherited large project. may take me bit find files/code.
here query achieve this:
select convert(varchar(20),getdate(),120)
also, if want additional zeros @ end:
convert(varchar(20),getdate(),120)+'.0000000'
Comments
Post a Comment