Data generator, unusual date format options

[andyh]

I wanted to produce random dates including hours and minutes.

I used Random(3/8/2004 06:00, 3/10/2004 06:00)

This would only work if the options tab date format was set to dd/mm/yyyy hh:mm.

The hh:mm seems an unusual format to me - hh24:mi placed the '24' and the 'i' into the generated data.

 

[Marco Kalter]

You can only specify Windows date formats. Oracle format options like hh24 and mi are not possible.

 

[andyh]

Ah... OK!

I didn't see that in the documentation.

 

[Jim Czuprynski]

Could you please define "Windows date formats"? Do you mean like 'mm/dd/yyyy hh:mm:ss'?

 

[Marco Kalter]

Yes, that's what I mean.

 

[Jim Czuprynski]

Got it working, just in time for my demo today! Thanks, Marco.