The songs required by different formats are required, and they can be placed in Bean.

According to the requirements of the different formats of the date, the date-type variable removed from the database is processed. When output, the output variable is already a form of painting.

A total of three forms:

Switch (dbvendor) {case 1: returndate = "to_date ('" bvdate.format ("strftime:% m /% D /% y" (Ignoretime? ":"% h:% m:% s ") ) "',' Mm / dd / yyyy" (Ignoretime? ":" HH24: MI: SS ") " "" "; break; case 2: returndate =" '" bvdate.format (" strftime :% Y-% M-% D " (Ignoretime?": "% H:% m:% s")) (Ignoretime? "00:00:00": "") "" Break Case 3: returndate = "Convert (datetime, '" bvdate.format ("StrfTime:% y /% m /% D" (Ignoretime? ":"% H:% m:% s ")) (ignoretime? 00:00:00 ":") "')"; Break;}