Timestamp comparision

ravitell1 · Post by **ravitell1** » Sat Aug 28, 2010 2:51 pm

Hello all,

I have a timestamp coming as" 2008-10-21 13:14:44.997187"

need to check that 2008 is numeric or not...

Please help me..

chulett · Post by **chulett** » Sat Aug 28, 2010 2:55 pm

Why not just use the IsValid function and see if it is a valid timestamp or not. Ah... Server... Ray Wurlod has a Server version freely available from his website, from what I recall.

ravitell1 · Post by **ravitell1** » Sat Aug 28, 2010 3:11 pm

thanks for the speedy response..

Actually i need to convert the above timestamp format to mmddyyyy..
then i need to compare whether the yyyy is numeric or not...

ray.wurlod · Post by **ray.wurlod** » Sat Aug 28, 2010 4:41 pm

Code: Select all

Left(Trim(InLink.TheTimestamp),4) Matches "4N"

will test for yyyy consisting of four numeric characters.

You can use a mix of Iconv() and Oconv() functions to change the format. Please advise your exact output format requirement.

ravitell1 · Post by **ravitell1** » Sat Aug 28, 2010 4:56 pm

how to convert the timestamp to date..
Need to convert "2008-10-21 13:14:44.997187" to the format MMDDYYYY
and then check whether yyyy is numeric or not...

chulett · Post by **chulett** » Sat Aug 28, 2010 6:33 pm

What is your target? MMDDYYYY is not a DATE data type so you may in fact need something else, that or you may just need to substring off the date from the time.

ray.wurlod · Post by **ray.wurlod** » Sun Aug 29, 2010 1:52 am

What do you want to do with the time component of the timestamp?

What is the data type of the target? Assuming it's a string of some kind, then one answer is

Code: Select all

Oconv(Iconv(Field(InLink.TheTimestamp, " ", 1, 1), "DYMD"), "DMDY[2,2,4]" : @VM : "MCN")

ravitell1 · Post by **ravitell1** » Sun Aug 29, 2010 11:27 am

The Senario is i need to convert the timestamp to MMDDYYYY and check the YYYY is numeric or not
If numeric send MMDDYYYY else send space
... to a seqential file...which in turn used to load into warehouse..

ray.wurlod · Post by **ray.wurlod** » Sun Aug 29, 2010 12:27 pm

I have provided everything you need except the If..Then..Else construct.

ravitell1 · Post by **ravitell1** » Sun Aug 29, 2010 1:11 pm

ray.wurlod wrote:I have provided everything you need except the If..Then..Else construct. ...

Thanks it worked...