Avatar of triphen

asked on 

SyBase SQL DataTime Format

Sybase SQL Anywhere v10

I am using CONVERT(VARCHAR(20),t1.timeord, 100) and I get "Mar 07 2014 05:06PM"

I want shortened date and I need the seconds as well. 03/07/14 05:06:19PM

Thanks in advance.
Sybase DatabaseSQL

Avatar of undefined
Last Comment

8/22/2022 - Mon