Date Format "2009-03-06T09:00:00"

[Jeff Barnes]

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

[nageswaragunupudi]

If you are using XHarbour

Code: Select all  Expand view

  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: Select all  Expand view

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

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

[Jeff Barnes]

Thanks, it works now.

Based on your help I ended up using this:

Code: Select all  Expand view

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")

[nageswaragunupudi]

You can also write

Code: Select all  Expand view

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