How to set date format in sybase?

Question

Currently it's inserting default date format Jan 9 2014 1:07AM to Sybase DB,But i have to insert seconds also like "20140109 01:06:46"

Is there any way i can set date format in stored proc.

please suggest me,thanks!

Look up how to do it in SQL Server, and just do that. – Elliott Frisch Jan 09 '14 at 06:26 — Elliott Frisch, Jan 09 '14 at 06:26

score 0 · Accepted Answer · answered Jan 09 '14 at 13:35

0

select --cast(
        dateformat('Jan 9 2014 1:07AM','YYYYMMDD HH:NN:SS') --returns varchar
        --as datetime) --datetime object in database datetime format

answered Jan 09 '14 at 13:35

Boggio

1,128
11
16

Thank! Have changed Data type smalldatetime to datetime in stored proc,it works fine. – Jan 09 '14 at 14:21

How to set date format in sybase?

1 Answers1

Linked