VRS_DEVICEID VRS_UTCTIME VRS_SPEED VRS_LOCATION ------------- ----------- --------- ------------- ST0001 2012-07-02 10:59:26.000 0.36 attigal ST0001 2012-07-02 11:33:36.000 40 tvm ST0001 2012-09-06 18:45:29.000 0.26 malappuram ST0001 2012-09-06 19:46:28.000 0.36 kozhikode ST0001 2012-10-09 12:10:12.000 50 idukki ST0001 2012-10-09 01:12:12.000 40 vayanadu
VRS_DEVICEID VRS_UTCTIME VRS_SPEED VRS_LOCATION ------------- ----------- --------- ------------- ST0001 2012-07-02 0.36 attigal ST0001 2012-07-02 40 tvm ST0001 2012-09-06 0.26 malappuram ST0001 2012-09-06 0.36 kozhikode ST0001 2012-10-09 50 idukki ST0001 2012-10-09 40 vayanadu
SELECT VRS_DEVICEID, CONVERT(VARCHAR(10), VRS_UTCTIME, 121) AS VRS_UTCDATE, VRS_SPEED, VRS_LOCATION FROM Table1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)