Prasad,
I forgot to answer your second question:
>>Also I wanted to know if there is any table in sybase like the
"dual" present in ORACLE
What do you want it for? 'Select sysdate from dual' kind of stuff
Sybase doesn't find anything wrong with the 'From' clause missing.
So,
Select getdate()
is a valid SQL query.
> -----Original Message-----
> From: Moganna, Prasad [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 25, 1999 2:29 PM
> To: '[EMAIL PROTECTED]'
> Subject: [ND] Equivalent date format in Sybase......
>
> One of my dataobjects retrieves data from the sybase database which is
> located
> at a remote place.
>
> I wanted to know the equivalent date format functions in Sybase. just like
> in ORACLE you have
> TO_CHAR('06/24/1999', 'mm/dd/yyyy') and to_date('03/24/1997',
> 'mm/dd/yyyy')
>
> Also I wanted to know if there is any table in sybase like the "dual"
> present in ORACLE
>
>
> Thanks In Advance,
> Prasad
> _________________________________________________________________________
>
> For help in using, subscribing, and unsubscribing to the discussion
> forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
>
> For dire need help, email: [EMAIL PROTECTED]
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
