powershell - how to Get-Date -

i have following

foreach($res in $result1)     {         $ed = $res.event_date     } 

$ed

29 september 2015 00:00:00

(it comes out of mysql database '2015-09-29' - i'm assuming powershell being 'clever' , converting it).

however, need display '

2015-09-27

i tried:

$ed = $res.event_date $ed = get-date -date $ed 

with intention of formatting accordingly, gives me

get-date : cannot bind parameter 'date' target.  exception setting "date": "object reference not set instance of object." 

what correct way of formatting display required?

how powershell displays depends on locale info. example:

d:\> get-date "29 september 2015 00:00:00"  tuesday, september 29, 2015 12:00:00  d:\> get-date "29 september 2015 00:00:00" -format yyyy-mm-dd 2015-09-29 

so might try this:

foreach($res in $result1)     {         $ed = get-date $res.event_date -format yyyy-mm-dd     }