topic-15797

Board index FiveWin for Harbour/xHarbour Date Format "2009-03-06T09:00:00"

Jeff Barnes

Posts: 933

Joined: Sun Oct 09, 2005 01:05 PM

Date Format "2009-03-06T09:00:00"
Posted: Thu Jun 04, 2009 12:15 AM

Hi,

I need to send a date/time combination as a Date ... how can this be done?

I need it in this format:
2009-03-06T09:00:00

Thanks,

Jeff Barnes

(FWH 16.11, xHarbour 1.2.3, Bcc730)

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Date Format "2009-03-06T09:00:00"
Posted: Thu Jun 04, 2009 02:05 AM

If you are using XHarbour

Code (fw): Select all Collapse

   local d  := datetime()

   Set( _SET_DATEFORMAT, 'YYYY-MM-DD' )
   SET TIME FORMAT TO 'HH:MM:SS'

   MsgInfo( TToC( d ) )

Using Harbour or XHarbour, another method:

Code (fw): Select all Collapse

   MsgInfo( cValToStr( d, 'YYYY-MM-DD' ) + ' ' + Time() )

Second method works without changing the Date Format. cValToStr() is FWH function.

Regards

G. N. Rao.

Hyderabad, India

Jeff Barnes

Posts: 933

Joined: Sun Oct 09, 2005 01:05 PM

Re: Date Format "2009-03-06T09:00:00"
Posted: Sun Jun 07, 2009 12:13 AM

Thanks, it works now.

Based on your help I ended up using this:

Code (fw): Select all Collapse

Set( _SET_DATEFORMAT, 'YYYY-MM-DD' )
SET TIME FORMAT TO 'HH:MM:SS'
dTimeStart := CtoT( DtoC(Date())+" 09:00:00")
dTimeEnd   := CtoT( DtoC(Date())+" 10:00:00")

Thanks,

Jeff Barnes

(FWH 16.11, xHarbour 1.2.3, Bcc730)

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Date Format "2009-03-06T09:00:00"
Posted: Sun Jun 07, 2009 12:29 AM

You can also write

Code (fw): Select all Collapse

dTimeStart := Date() + 9/24
dTimeEnd := Date() + 10/24

Regards

G. N. Rao.

Hyderabad, India

FiveTech Support Forums

Continue the discussion