数据库,如Oracle,mysql,sqlserver
开发语言,如java,python
在Oracle中:varchar转int:to_number(),例子:to_number('666')varchar转date:to_date(),例子:to_date('2018-01-01 12:00:00','yyyy-mm-dd hh24:mi:ss')
在mysql中:varchar转int:cast(),convert(),例:cast('123' as int),convert('123',int)varchar转date:str_to_date('2018-01-01 12:00:00','%Y%m%d %H:%i:%s')
在sqlserver中:varchar转int:cast(),convert(),例:cast('123' as int),convert('123',int)varchar转date:cast('2018-01-01 12:00:00' as datetime),convert('2018-01-01 12:00:00',datetime)
在java中:String转换为IntString str = '10'; Integer it = new Interger(str); String转换为java.util.DateString str = '2018-01-01'; SimpleDateFormat sdf = new SimpleDateFormat('yyyy-MM-dd'); Date date = null; //初始化date date = sdf.parse(str);
在Python中:string转化为int:10进制string转化为int int('12')16进制string转化为int int('12', 16)string转date:form datetime import datetimestart_date = datetime.strptime('2018-01-01', '%Y-%m-%d')