使用DataWeave在Mule中转换为日期格式 [英] Converting to a date format in Mule using DataWeave
问题描述
我的要求是使用Mule中的DataWeave将字符串转换为日期格式
My requirement is to convert a string to a date format using DataWeave in Mule
输入字符串
8/30/2015 4:00:13 PM
输出日期必须采用MM/DD/YYYY格式，即
Output date needs to be in MM/DD/YYYY format i.e,
08/30/2015
我尝试使用以下逻辑
(($[1] splitBy " ")[0]) as :date{format:"[m01]/[d01]/[y0001]"}
这给出了错误
Exception while executing:
"Order Date":(($[1] splitBy " ")[0]) as :date{format:"[m01]/[d01]/[y0001]"},
Cannot coerce a :string to a :date ^
我正在使用Mule Anypoint Studio版本:5.2.0
I am using Mule Anypoint Studio Version: 5.2.0
推荐答案
首先，您需要将其转换为localdatetime(无时区)，然后再转换为具有所需格式的字符串.
First you need to convert it to a localdatetime (no timezone) and then to a string with the desired format.
"8/30/2015 4:00:13 PM"
as :localdatetime {format: "M/dd/yyyy h:mm:ss a"}
as :string {format: "MM/dd/yyyy"}
在Mule 4的DataWeave 2.0中应该是
In DataWeave 2.0 in Mule 4 it should be
"8/30/2015 4:00:13 PM"
as LocalDateTime {format: "M/dd/yyyy h:mm:ss a"}
as String {format: "MM/dd/yyyy"}
有关其他信息，请参见. https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.html
For additional info see. https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.html
All letters 'A' to 'Z' and 'a' to 'z' are reserved as pattern letters. The following pattern letters are defined:
Symbol Meaning Presentation Examples
------ ------- ------------ -------
G era text AD; Anno Domini; A
u year year 2004; 04
y year-of-era year 2004; 04
D day-of-year number 189
M/L month-of-year number/text 7; 07; Jul; July; J
d day-of-month number 10
Q/q quarter-of-year number/text 3; 03; Q3; 3rd quarter
Y week-based-year year 1996; 96
w week-of-week-based-year number 27
W week-of-month number 4
E day-of-week text Tue; Tuesday; T
e/c localized day-of-week number/text 2; 02; Tue; Tuesday; T
F week-of-month number 3
a am-pm-of-day text PM
h clock-hour-of-am-pm (1-12) number 12
K hour-of-am-pm (0-11) number 0
k clock-hour-of-am-pm (1-24) number 0
H hour-of-day (0-23) number 0
m minute-of-hour number 30
s second-of-minute number 55
S fraction-of-second fraction 978
A milli-of-day number 1234
n nano-of-second number 987654321
N nano-of-day number 1234000000
V time-zone ID zone-id America/Los_Angeles; Z; -08:30
z time-zone name zone-name Pacific Standard Time; PST
O localized zone-offset offset-O GMT+8; GMT+08:00; UTC-08:00;
X zone-offset 'Z' for zero offset-X Z; -08; -0830; -08:30; -083015; -08:30:15;
x zone-offset offset-x +0000; -08; -0830; -08:30; -083015; -08:30:15;
Z zone-offset offset-Z +0000; -0800; -08:00;
p pad next pad modifier 1
' escape for text delimiter
'' single quote literal '
[ optional section start
] optional section end
# reserved for future use
{ reserved for future use
} reserved for future use
这篇关于使用DataWeave在Mule中转换为日期格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
