转换函数

Question

oracle下面语句怎么转换，感谢
这是sql的使用，想转换oracle，需要怎么写
convert(char(10),w2.createddate-datepart(w,w2.createddate)+1,111)+'-'+
convert(char(10),w2.createddate+(7-datepart(w,w2.createddate)),111)

Answer 1

convert(char(10),date,111) --→ to_date(date,'yyyy-mm-dd')

Answer 2

createddate是datetime类型吧？
datepart(w,w2.createddate) --→to_char(w2.createddate,'W')convert(char(10),w2.createddate-datepart(w,w2.createddate)+1,111)+'-'+
convert(char(10),w2.createddate+(7-datepart(w,w2.createddate)),111)--→to_char(w2.createddate-to_char(w2.createddate,'W')+1,'yyyy-mm-dd')||'-'||
to_char(w2.createddate+7-to_char(w2.createddate,'W'),'yyyy-mm-dd')

Answer 3

to_char(w2.createddate+7-to_char(w2.createddate,'W'),'yyyy-mm-dd')少了个括号to_char(w2.createddate+（7-to_char(w2.createddate,'W')）,'yyyy-mm-dd')
应该是这样吧，不过还是谢谢这位朋友

Answer 4

你的sql俺看不懂啊，爱莫能助