Talend

ID #1112

Format de date et de temps

Lettre

Date ou temps

Présentation

Exemples

G

Siècle

Texte

AD

y

Année

Year

1996; 96

M

Mois de l'année

Month

July; Jul; 07

w

Semaine dans l'année

Number

27

W

Semaine du mois

Number

2

D

Jour de l'année

Number

189

d

Jour du mois

Number

10

F

Jour de la semaine

Number

2

E

Jour de la semaine

Text

Tuesday; Tue

a

Am/pm

Text

PM

H

Heure du jour (0-23)

Number

0

k

Heure du jour (1-24)

Number

24

K

Heure en am/pm (0-11)

Number

0

h

Heure en am/pm (1-12)

Number

12

m

Minute

Number

30

s

Seconde

Number

55

S

Milliseconde

Number

978

z

Time zone

General time zone

Pacific Standard Time; PST; GMT-08:00

Z

Time zone

RFC 822 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:

Dernière mise à jour: 2014-04-11 08:57
Auteur: Michel Preti
Révision: 1.2

Digg it! Imprimer cet article Envoyer à un ami version PDF
Propose a translation for Propose a translation for
Merci de noter cette entrée:

Moyenne des notes: 0 sur 5 (0 Votes)

complètement inutile 1 2 3 4 5 indispensable

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