Talend
Format de date et de temps
Lettre |
Date ou temps |
Présentation |
Exemples |
G |
Siècle |
AD |
|
y |
Année |
1996; 96 |
|
M |
Mois de l'année |
July; Jul; 07 |
|
w |
Semaine dans l'année |
27 |
|
W |
Semaine du mois |
2 |
|
D |
Jour de l'année |
189 |
|
d |
Jour du mois |
10 |
|
F |
Jour de la semaine |
2 |
|
E |
Jour de la semaine |
Tuesday; Tue |
|
a |
Am/pm |
PM |
|
H |
Heure du jour (0-23) |
0 |
|
k |
Heure du jour (1-24) |
24 |
|
K |
Heure en am/pm (0-11) |
0 |
|
h |
Heure en am/pm (1-12) |
12 |
|
m |
Minute |
30 |
|
s |
Seconde |
55 |
|
S |
Milliseconde |
978 |
|
z |
Time zone |
Pacific Standard Time; PST; GMT-08:00 |
|
Z |
Time zone |
-0800 |
Exempless pratiques d'utilisation :
TalendDate.formatDate("yyyy-MM-dd'T'HH:mm:ss.SSSZ", row1.DTCREATION)
2014-04-11T12:08:56.235-0700
Â
Date et temps |
RĂ©sultat |
"yyyy.MM.dd G 'at' HH:mm:ss z" |
2001.07.04 AD at 12:08:56 PDT |
"EEE, MMM d, ''yy" |
Wed, Jul 4, '01 |
"h:mm a" |
12:08 PM |
"hh 'o''clock' a, zzzz" |
12 o'clock PM, Pacific Daylight Time |
"K:mm a, z" |
0:08 PM, PDT |
"yyyyy.MMMMM.dd GGG hh:mm aaa" |
02001.July.04 AD 12:08 PM |
"EEE, d MMM yyyy HH:mm:ss Z" |
Wed, 4 Jul 2001 12:08:56 -0700 |
"yyMMddHHmmssZ" |
010704120856-0700 |
"yyyy-MM-dd'T'HH:mm:ss.SSSZ" |
2001-07-04T12:08:56.235-0700 |
Tags: date temps talend format
Related entries:
Auteur: Michel Preti
Révision: 1.2
Vous ne pouvez pas commenter cet enregistrement
Commenté par 5Tkqrf8nJZP4:
That's the default out of the box date, which is prbbloay for compatibility back to the 1920s or something. I think the DBA can change the default date, from what I've seen they tend not to bother.Also ROWNUM gets more fun if you want to return 11 through 20. Something like:SELECT * FROM (SELECT *,ROWNUM as row FROM table) WHERE row BETWEEN (11,20)
Added at: 2015-10-19 03:32
Commenté par Lx5fleSttG:
Nice post! I'm huge fan of Flashback as well, even added several faetures in APEX based on it (Undo region source, Flashback export). The SQL Dev team just added a bunch of Flashback faetures to that product, and the APEX team included Flashback in Interactive Reports (3.1 feature, I had nothing to do with this one).If you have any cool ideas for an APEX + Flashback demo (especially 11g Total Recall), the team that developed flashback would love to hear about. If you think of anything, drop me an email or a note on my blog.Keep up the great work! http://hqwlofp.com [url=http://mcfafeogs.com]mcfafeogs[/url] [link=http://doqvhqb.com]doqvhqb[/link]
Added at: 2015-10-22 09:39
Commenté par A2BVk8KX5nk:
I was super glad that Kris won, since he also plays the piano, guitar, etc.! His more style is more coveintnonal and American. I'm sure Adam will do just fine with the kick start he received.
Added at: 2015-12-21 09:13
Commenté par xoDP7YwH8Lm:
I think it turned out the best for eevryone. Adam is a superstar and doesn't need idol Kris is such a sweetheart and can benefit from what idol can offer him!!! I love AI http://fhgwzhz.com [url=http://vsvfpt.com]vsvfpt[/url] [link=http://rtbrjgj.com]rtbrjgj[/link]
Added at: 2015-12-23 01:08