Re: extract year-month-day-hour

2014-09-18 Thread Peter Brawley
On 2014-09-18 5:25 PM, Jopoy Solano wrote: Hi! I want to say sorry in advance for my ignorance. I was wondering how can I extract year-month-day-hour in one go. For example: From 2014-09-17 12:22:16 to 2014-09-17 12 Is this what you mean? date_format( tsvalue, '%Y-%m-%d %H' ) PB -

Re: extract year-month-day-hour

2014-09-18 Thread Mihail Manolov
Try this: LEFT('2014-09-17 12:22:16', 13) Mihail Manolov Senior Manager, Database Liquidity Services, Inc. 1920 L Street NW Washington DC 20036 202-467-6868 x3227 (Office) 202-256-9044 (Mobile) mihail.mano...@liquidityservices.com LiquidityServicesInc.com On Sep 18, 2014, at 18:31, Jopoy

RE: extract year-month-day-hour

2014-09-18 Thread Prashant Ramhit
2014 03:20 To: m...@jopoy.com Cc: mysql@lists.mysql.com Subject: Re: extract year-month-day-hour Try this: LEFT('2014-09-17 12:22:16', 13) Mihail Manolov Senior Manager, Database Liquidity Services, Inc. 1920 L Street NW Washington DC 20036 202-467-6868 x3227 (Office) 202-256-9044 (Mobile