RE: extract year-month-day-hour

2014-09-18 Thread Prashant Ramhit
__ From: Mihail Manolov [mihail.mano...@liquidityservices.com] Sent: 19 September 2014 03:20 To: 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 Servic

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 Sol

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 -