TimeStamp ?

A timestamp is generally a Databse vocabullary wich means a date format, the real stored dateformat that you’ll certianlly not remark else you’ve already read about it, in the database, the date and time and stored together in the fomrat [Date] : [Time] >> mm/dd/yyyy: hh:mm:ss, so where you intend to inset a date row, the data will be in this : 10/05/2003 00:00:00 and when dealing with time only you get this 12/31/9999 10:30:32 it’s a technique that makes the storing effort more easy for the DBMS (Data Base Managamement System). That’s why it’s always advised to try to make use of that’s feature, not just for the data itself but maybe for other purposes for example when inserting the date of an operation such as sale, stock entry, it would be very usesfull to inset the time within when that date row cost time and date, so why passing through !

Advertisements

2 Comments Add yours

  1. wadid says:

    veryuseful..Really

  2. karim says:

    It’s true for interbase too !

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s