[Logo] Enterprise Client Community
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Format a date variable coming from the Database  XML
Forum Index -> Deployment
Author Message


Joined: 29/09/2020 14:14:26
Messages: 21

Hello Björn,

following problem:

I read a numeric variable with date from the database:
endDatum: 190125

that would be:
short = 25.01.19
long = 25.01.2019

if I include the variable in the jsp I always get 190125.
I've tried everything, format, formatrule, formatmask,
no success.

Where is the mistake?


Power User

Joined: 21/11/2007 12:23:06
Messages: 5545


you need to convert. There are two possibilities:

1. "good old" java.util.Date - use a Calendar function to convert. Pay attention to timezone issues! (!!!)

2. >= Java 1.7 (or 1.8??). Convert to Java's LocalDate. In the layout definition use TIMEZONE="LOCAL"! (!!!)

I believe 2. is the simpler variant for you, because you do not have to pay attention to timezone issues on server side. LocalDate has nice function to get created from y,m,d-information.

(and for accurate people: yes, there is a 3. posibility: you may use long, the long being the timestamp value behind a java.util.Date...)

Regards, Björn

PS: In the developer's Guide there is an own chapter on Date-management - because this is something that typically is not correctly managed in projects...

Björn Müller, CaptainCasa GmbH


Joined: 29/09/2020 14:14:26
Messages: 21

Thnxx Björn
Forum Index -> Deployment
Go to:   
Powered by JForum 2.1.6 © JForum Team