摘要：Select CONVERT(varchar(100), GETDATE(), 0): 07 16 2012 10:57AM Select CONVERT(varchar(100), GETDATE(), 1): 07/16/12 Select CONVERT(varchar(100), GETDATE(), 2): 12.07.16 Select CONVERT(varchar(100), GETDATE(), 3): 16/07/12 Select CONVERT(varchar(100), GETDATE(), 4): 16.07.12 Select CONVERT(varchar(10 阅读全文

摘要：点是否在圆内：select *from table awhere SQRT(power(a.LONGITUDE - 116.3676095557983, 2) + power(a.LATITUDE - 39.913205912837014, 2)) <= 0.039790863734664776点是否在多边形内：select * from table a, (select MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_... 阅读全文