sybase没用过,但我用过Oracle和SQL Server[Oracle]
select to_char('yyyy',fieldname),to_char('mm',fieldname),to_char('dd',fieldname) from tablename[SQL Server]
select Year(fieldName),month(fieldname),day(fieldname) from tablename
select to_char('yyyy',fieldname),to_char('mm',fieldname),to_char('dd',fieldname) from tablename[SQL Server]
select Year(fieldName),month(fieldname),day(fieldname) from tablename
datepart(month,getdate())
datepart(day,getdate())