var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I want to search for documents created between different dates. Therefore I want to store a date in the format yyyy-mm-dd, but the databases store it as yyyy-mm-dd 00:00:00.000
how do I get rid of the hours and minutes?
you cannot get rid of them, they are part of the datatype
store your date values without a time component, and then when you search for a date range, you'll be fine
the only way people get into trouble is when they store values like getdate() which include an actual time
rudy.ca | @rudydotca
Buy my SitePoint book: Simply SQL
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors