datetime v mysql
Tom Hudec
Tom na ABBA.cz
Pondělí Květen 6 04:39:28 CEST 2002
Tom Hudec wrote:
> Petr Vanek wrote:
> mysql> select id from articles where DATE_FORMAT(dt,'%Y-%m-%d') =
> '2002-05-05';
Jeste me napadlo mozna cistsi reseni:
select id from articles where sdate between
'2002-05-05' and '2002-05-05' + INTERVAL '23:59:59' HOUR_SECOND;
--
Tom Hudec <Tom(at)ABBA.cz>, editor of Tom's ABBA pages http://ABBA.cz/
.''`. The box said Windows, NT or better, so I installed Linux. :-)
: :' :
`. `' Debian GNU/Linux http://www.debian.org/ http://www.debian.cz/
`- The Perfect OS - the most software, the most people
Další informace o konferenci Test