DataTime string format

[barry]

Hi

does anyone know which format character i should use to get the the
following date string

2006-01-30T22:00:00.0000000-08:00

if i use 's' format i get
2006-01-30T22:00:00

TIA
Barry

[Flinky Wisty Pomm]

You need to build a custom date formatting string, I think. Reference
here
[http://msdn.microsoft.com/library/de...atstrings.asp]
but it looks like you want

"yyyy-MM-dd\THH\:mm\:ss-fffffff-zzz"

some of the backslashes may be superfluous, but that's off the top of
my head, so I've erred on the side of caution.

[Kevin Spencer]

Yes, the backslashes are not necessary. The colon character does not require
escaping.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
We got a sick zebra a hat,
you ultimate tuna.
"Flinky Wisty Pomm" <Pa********@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

You need to build a custom date formatting string, I think. Reference
here
[http://msdn.microsoft.com/library/de...atstrings.asp]
but it looks like you want

"yyyy-MM-dd\THH\:mm\:ss-fffffff-zzz"

some of the backslashes may be superfluous, but that's off the top of
my head, so I've erred on the side of caution.

[Flinky Wisty Pomm]

Would have helped if I'd read the reference myself, wouldn't it?

Does anyone know, though - if I require the format given by the OP, and
I use the "/" and ":" characters for date/time separator, will they
change depending on the globalisation settings in use? I imagine the
date separator will, but is the semi-colon standard worldwide?
Kevin Spencer wrote:

Yes, the backslashes are not necessary. The colon character does not require
escaping.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
We got a sick zebra a hat,
you ultimate tuna.
"Flinky Wisty Pomm" <Pa********@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

You need to build a custom date formatting string, I think. Reference
here
[http://msdn.microsoft.com/library/de...atstrings.asp]
but it looks like you want

"yyyy-MM-dd\THH\:mm\:ss-fffffff-zzz"

some of the backslashes may be superfluous, but that's off the top of
my head, so I've erred on the side of caution.

[Kevin Spencer]

> Does anyone know, though - if I require the format given by the OP, and

I use the "/" and ":" characters for date/time separator, will they
change depending on the globalisation settings in use?
No, because what you will have afterwards is a string, not a DateTime.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
We got a sick zebra a hat,
you ultimate tuna.
"Flinky Wisty Pomm" <Pa********@gmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com... Would have helped if I'd read the reference myself, wouldn't it?

Does anyone know, though - if I require the format given by the OP, and
I use the "/" and ":" characters for date/time separator, will they
change depending on the globalisation settings in use? I imagine the
date separator will, but is the semi-colon standard worldwide?
Kevin Spencer wrote:

Yes, the backslashes are not necessary. The colon character does not
require
escaping.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
We got a sick zebra a hat,
you ultimate tuna.
"Flinky Wisty Pomm" <Pa********@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

> You need to build a custom date formatting string, I think. Reference
> here
> [http://msdn.microsoft.com/library/de...atstrings.asp]
> but it looks like you want
>
> "yyyy-MM-dd\THH\:mm\:ss-fffffff-zzz"
>
> some of the backslashes may be superfluous, but that's off the top of
> my head, so I've erred on the side of caution.
>