topic-18282

Posts: 811

Joined: Tue May 06, 2008 04:28 AM

TimeStamp Format
Posted: Sat Mar 06, 2010 02:05 AM

Hello All,

I would like a a timestamp format from "mm/dd/yyyy hh:mm:ss PM" TO "mm/dd/yyyy hh:mm:ss"

I tried to Set( _SET_TIMEFORMAT, "HH:MM") but still with 'AM' or 'PM'..

Regards,
FAP

Kind Regards,

Frances

Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: TimeStamp Format
Posted: Sat Mar 06, 2010 02:26 AM

SET TIME FORMAT TO 'HH:MM PM' works.

Regards

G. N. Rao.

Hyderabad, India

fraxzi

Posts: 811

Joined: Tue May 06, 2008 04:28 AM

Re: TimeStamp Format
Posted: Sat Mar 06, 2010 03:59 AM

nageswaragunupudi wrote:SET TIME FORMAT TO 'HH:MM PM' works.

Dear RAO,

I wish to remove 'AM' or 'PM'

Actually I'm following your logic in updating local table from server...

with ADS...

DOESNT WORK

Code (fw): Select all Collapse

 SELECT  * FROM table WHERE timestamp_field > 'mm:dd:yyyy hh:mm:ss AM'

WORKING

Code (fw): Select all Collapse

 SELECT  * FROM table WHERE timestamp_field > 'mm:dd:yyyy hh:mm:ss'

Regards,
FAP

Kind Regards,

Frances

Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: TimeStamp Format
Posted: Sat Mar 06, 2010 07:34 AM

SET TIME FORMAT TO 'HH:MM' or 'HH:MM:SS' without adding ' PM' shows time in 24 hour format

Regards

G. N. Rao.

Hyderabad, India

fraxzi

Posts: 811

Joined: Tue May 06, 2008 04:28 AM

Re: TimeStamp Format
Posted: Mon Mar 08, 2010 12:56 AM

Dear RAO,

nageswaragunupudi wrote:SET TIME FORMAT TO 'HH:MM' or 'HH:MM:SS' without adding ' PM' shows time in 24 hour format

I tried Set( _SET_TIMEFORMAT, "HH:MM") or Set( _SET_TIMEFORMAT, "HH:MM:SS") and
SET TIME FORMAT TO 'HH:MM' or 'HH:MM:SS' .... but still with AM/PM

I end up trimming the last 2 chars. it works but not ideal.

Regards,
FAP

Kind Regards,

Frances

Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15

FiveTech Support Forums

Continue the discussion