Sybase conversion of a field

building semantic layer
1

To all unfortunate souls working still:

In the process of converting a universe from Oracle to Sybase, I have a ‘problem child’ field.

In Oracle, it was a string with a value of
Format(SomeDate, “YYYYMMDDHHMISS”)

Sybase does not have a Format, so how do I get there from here?

Feliz Navidad!

JayDon

Listserv Archives (BOB member since 2002-06-25)

2

Jay,

Use the CONVERT(, your_string) or CONVERT(, your_string) expression in your object’s SELECT equivalent: this is a TRANSACT-SQL function that you can find fully documented under http:///sybooks.sybase.com. Once you get there, search in chapter 9 of the TRANSACT SQL guide for more info.

It is the kind of online documentation web site w/ search engine that all db vendors should have…my 2 cents.

Good luck & Joyeux Noel!

Listserv Archives (BOB member since 2002-06-25)

3

Another possible solution is using the FormatDate function on the reporter side. Some time ago I turned to using this function only to convert date’s to strings as the default sort functions (day and month) in reporter didn’t work on convertions on the middle tier

hans

Use the CONVERT(, your_string) or CONVERT(, your_string) expression in your object’s SELECT equivalent: this is a

In the process of converting a universe from Oracle to Sybase, I
have a
‘problem child’ field.
In Oracle, it was a string with a value of
Format(SomeDate, “YYYYMMDDHHMISS”)
Sybase does not have a Format, so how do I get there from here?

Listserv Archives (BOB member since 2002-06-25)