DATETIME formatting in Cloudbase

[Matt Garren]

I created a table in CLOUDBASE which has both date and time fields.
For the date field, I fed in "...format 'yyMMdd'", and for the time
field I fed in "...format 'hhmmss'". The date displays correctly, but
the time does not, it displays as a date. Have I made an error in my
CREATE statement with the formats, or should I have been more specific
than SELECT * on my query?

[Tarandeep]

Are you using Squirrel as a client?
In that case, please check the display settings of the squirrel. I
remember I had to change it to display time properly. But I can't seem
to remember it properly...

[jingchao]

I used JiSQL as CLI client before and found that JiSQL can't display
the whole String if the content of a column is too long. So the "yyyy/
MM/dd HH:mm:ss" may be cut off and only leave "yyyy/MM/dd" when
SELECT in JiSQL, but when you use Java program you will find the
whole Date String is well stored in CloudBase.

[mgarren]

Thanks guys, that's good to know. It sounds like it's really not even
an issue since most of my implementation will be Java. I was just
using squirrel to check correctness.