Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It took me a few reads to fully grasp what the problem was, but it sounds like you know how to do the formatting with Spring but are having issues with the fact that jquery uses different patterns than Java when formatting a Date? I believe your best recourse may be to simply store two patterns in your properties:</p> <pre><code>java.date.format=yyyy-MM-dd... jquery.date.format=yyyy-mm-dd... </code></pre> <p>Obviously that means configuration would require making sure you used the equivalent format for each property so that they were always converted properly, but the only alternative I can see is creating an automatic format converter from jquery to java (or vice versa.)</p> <p>Alternatively, have you considered simply converting the date to milliseconds before submitting and then using that to recreate the Date on the java end? Would be much simpler, I imagine.</p> <p><strong>EDIT AFTER COMMENTS</strong></p> <p>Sounds like the goal is ultimately to have a single configurable property:</p> <pre><code>date.format=yyyy-mm-dd... </code></pre> <p>In order to avoid a complex mapping from jquery's date formatting tokens to Java's date formatting tokens, it might be best to simply create your own custom date format in the form of:</p> <pre><code>[millis],[timeZoneOffset] </code></pre> <p>Your properties file should contain the jquery format string so that your Datepicker will render the format you wish the client to see. Then, when a date is picked, you should convert it to your <code>[millis],[timeZoneOffset]</code> custom format before submitting to your controller. On the Spring/Java side, you should create and register a custom <code>Date</code> converter that accepts this <code>[millis],[timeZoneOffset]</code> format and creates the corresponding <code>Date</code> object.</p> <p>Personally, I don't see anything wrong with creating your own custom date format to solve this problem. You are going to save yourself a lot of headache that would come from trying to map jquery to Java, and, ultimately, it's what Spring's custom converters are there to help with.</p>
    singulars
    1. This table or related slice is empty.
    1. POImplement configurable date format in spring mvc and jquery
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMattSenter
    1. USMattSenter
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTBountyClose
    1. COI like your second solution, is there any setting in datepicker that will allow me to display dates in the date format I want and give the value in milliseconds?
      singulars
      1. PO
      1. USvarun
    2. COI realized that there will be a problem if I take datepicket input as milliseconds. Generally client and server have different time zones and it will be impossible to handle different timezones in this case.
      singulars
      1. PO
      1. USvarun
    3. COHmm good point. What if you used a custom converter that took a String like "[millis],[timeZoneOffset]" and converted that to a `Date` object in Java? That way, you could always use the jquery format string in your properties file, as the client is where the user will visibly see the date, and achieve the proper conversion without a need to map jquery's format to Java's.
      singulars
      1. PO
      1. USMattSenter
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload