<div>
adiemeer,<br />
<br />
It sounds like you're storing the date/time in a string format. &nbsp;Standard practice is to store date/times in the database native format. &nbsp;When you query the data, formatting functions (which can output almost any format) convert the internal date/time to whatever format you want. &nbsp;The functions are a little different depending on what database you're using. &nbsp;Which DB are you using?<br />
<br />
Regards,<br />
<br />
Aielloj
</div>


<div>
How is it I posted the answer, but got none of the points?
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I do have a website where I want to display the last date an user logged in. This information I have stored in a database. &nbsp;At this moment I use the pattern yyyy-MM-ddTHH:mm:ss.fff<br />
to identify the date. The pattern works well if the stored date is for example 2013-02-15T12:11:41.203. However if the stored date is 2013-02-15T12:11:41.20 this doesn't work well.<br />
<br />
How do I have to change the pattern yyyy-MM-ddTHH:mm:ss.fff to read both the dates well? I tried yyyy-MM-ddTHH:mm:ss.ff0, but that didn't work.<br />
<br />
Thanks!<br />
<br />
Regards Arne
</div>
</div>


Hello,

I do have a website where I want to display the last date an user logged in. This information I have stored in a database.  At this moment I use the pattern yyyy-MM-ddTHH:mm:ss.fff
to identify the date. The pattern works well if the stored date is for example 2013-02-15T12:11:41.203. However if the stored date is 2013-02-15T12:11:41.20 this doesn't work well.

How do I have to change the pattern yyyy-MM-ddTHH:mm:ss.fff to read both the dates well? I tried yyyy-MM-ddTHH:mm:ss.ff0, but that didn't work.

Thanks!

Regards Arne

adiemeer,

It sounds like you&#39;re storing the date/time in a string format.  Standard practice is to store date/times in the database native format.  When you query the data, formatting functions (which can output almost any format) convert the internal date/time to whatever format you want.  The functions are a little different depending on what database you&#39;re using.  Which DB are you using?

Regards,

Aielloj

How is it I posted the answer, but got none of the points?

How to choose the right date format

Hello,

I do have a website where I want to display the last date an user logged in. This information I have stored in a database.  At this moment I use the pattern yyyy-MM-ddTHH:mm:ss.fff
to identify the date. The pattern works well if the stored date is for example 2013-02-15T12:11:41.203. However if the stored date is 2013-02-15T12:11:41.20 this doesn&#39;t work well.

How do I have to change the pattern yyyy-MM-ddTHH:mm:ss.fff to read both the dates well? I tried yyyy-MM-ddTHH:mm:ss.ff0, but that didn&#39;t work.

Thanks!

Regards Arne

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.