Return to Answer

	2	deleted 9 characters in body source \| link	edited Mar 11 '18 at 6:03 Ashwini Mohan 4033 silver badges11 bronze badges
inline side-by-side side-by-side markdown I'll always prefer to store that as a single column unless there is some specific business/application demand. Below are my points - Extracting timestamptime from datetimestamptimestamp is not a problem Why to add extra column just for time if we can store both together To avoid add Date and Time each time whenever you are querying. I'll always prefer to store that as a single column unless there is some specific business/application demand. Below are my points - Extracting timestamp from datetimestamp is not a problem Why to add extra column just for time if we can store both together To avoid add Date and Time each time whenever you are querying. I'll always prefer to store that as a single column unless there is some specific business/application demand. Below are my points - Extracting time from timestamp is not a problem Why to add extra column just for time if we can store both together To avoid add Date and Time each time whenever you are querying.

	1	source \| link	answered Sep 20 '16 at 14:39 Ashwini Mohan 4033 silver badges11 bronze badges
I'll always prefer to store that as a single column unless there is some specific business/application demand. Below are my points - Extracting timestamp from datetimestamp is not a problem Why to add extra column just for time if we can store both together To avoid add Date and Time each time whenever you are querying.

Database Administrators Stack Exchange works best with JavaScript enabled