Sybase-Insert getdate()

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 392,045 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,306 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser:

Thread Tools Display Modes

Views: 789 | Replies: 0

•

Join Date: May 2008

Posts: 6

Reputation: gvalip is an unknown quantity at this point

Rep Power: 0

Solved Threads: 1

gvalip

Offline

Newbie Poster

Sybase-Insert getdate()

May 20th, 2008

I did following -

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
CREATE TABLE test_insert_date (field1 datetime NOT NULL)
GRANT ALL ON test_insert_date TO public
 
CREATE proc usp_test_ins_dt
@field1 datetime NULL 
AS
    SELECT @field1
    INSERT INTO test_insert_date
    VALUES (getdate())
 
    RETURN
create table test_insert_date (field1 datetime not null)
grant all on test_insert_date to public

create proc usp_test_ins_dt
@field1 datetime null 
as
    select @field1
    insert into test_insert_date
    values (getdate())

    return

After this, I executed the proc as -
usp_test_ins_dt getdate()
I got error as "Incorrect syntax near ')'."

But if I run the proc as
usp_test_ins_dt "01/01/2008"
It runs fine. Any help in understanding how Sybase is behaving?

Last edited by peter_budo : May 23rd, 2008 at 11:05 am. Reason: Keep It Organized - please use [code] tags