如何将日期格式设为“yyyy mm / dd”？(How to get date format as “yyyy mm/dd”?)

如何将日期格式设为“yyyy mm / dd”？(How to get date format as “yyyy mm/dd”?)

我试图从这个格式yyyy mm/dd输出一个时间戳字段，所以我尝试这样：

extract(year from mytable.order_date)||' '||extract(month from mytable.order_date)||'/'||extract(day from mytable.order_date),

但是没有填充零，所以我如何添加它们？

使用Firebird 3.0

I am trying to output a time stamp field from view in this format yyyy mm/dd so I tried like this:

extract(year from mytable.order_date)||' '||extract(month from mytable.order_date)||'/'||extract(day from mytable.order_date),

however there is no padding zeros so how I add them ?

using Firebird 3.0

最满意答案

您可以使用lpad函数填充0 ，即

extract(year from mytable.order_date) ||' '|| lpad(extract(month from mytable.order_date), 2, '0')||'/'|| lpad(extract(day from mytable.order_date), 2, '0')

You could use the lpad function to pad with 0, ie

extract(year from mytable.order_date) ||' '|| lpad(extract(month from mytable.order_date), 2, '0')||'/'|| lpad(extract(day from mytable.order_date), 2, '0')