TimeStamp conversion


#1

Hi,

I’ve got a TimeStamp field in MySql and want to use the hour and minutes
in the value.

for example:

StartTime = Schedule.find(action2.ScheduleID).DateTimeStart.to_s

That returns “Mon Feb 20 08:00:00 Romance Standard Time 2006”

How do I get 08:00 returned ??

Thanks !

Steven.


#2

Steven De Ryck wrote:

Hi,

I’ve got a TimeStamp field in MySql and want to use the hour and minutes
in the value.

for example:

StartTime = Schedule.find(action2.ScheduleID).DateTimeStart.to_s

That returns “Mon Feb 20 08:00:00 Romance Standard Time 2006”

How do I get 08:00 returned ??

Thanks !

Steven.

try “date.to_formatted_s format_string”

it uses the same syntax as strftime documented here:
http://www.rubycentral.com/ref/ref_c_time.html#strftime

I would write what you need like this:

start_time =
Schedule.find(action2.schedule_id).date_time_start.to_formatted_s("%H:%M")


#3

I allready tried that:

Schedule.find(action2.ScheduleID).DateTimeStart.to_formatted_s("%H:%M")

Still returns something like “Fri Feb 24 20:00:00 Romance Standard Time
2006” …

Steven.

Alex W. wrote:

Steven De Ryck wrote:

Hi,

I’ve got a TimeStamp field in MySql and want to use the hour and minutes
in the value.

for example:

StartTime = Schedule.find(action2.ScheduleID).DateTimeStart.to_s

That returns “Mon Feb 20 08:00:00 Romance Standard Time 2006”

How do I get 08:00 returned ??

Thanks !

Steven.

try “date.to_formatted_s format_string”

it uses the same syntax as strftime documented here:
http://www.rubycentral.com/ref/ref_c_time.html#strftime

I would write what you need like this:

start_time =
Schedule.find(action2.schedule_id).date_time_start.to_formatted_s("%H:%M")


#4

Nevermind, I solved it with:

" Schedule.find(action2.ScheduleID).DateTimeStart.strftime("%H:%M").to_s
"