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

Popular posts from this blog

html - How to style widget with post count different than without post count -

How to remove text and logo OR add Overflow on Android ActionBar using AppCompat on API 8? -

javascript - storing input from prompt in array and displaying the array -