12.有职员表:S(工号,姓名,性别,出生年月),假设要计算职工的年龄,则年龄字段的表达式为
2024-08-23数据库及其应用(02120)
12.有职员表:S(工号,姓名,性别,出生年月),假设要计算职工的年龄,则年龄字段的表达式为
A、Year(Now())-Year(‘出生年月’)
B、Now()-Year(#出生年月#)
C、Year(Now())-Year([出生年月])
D、Now()-Year(“出生年月”)
【正确答案】:C
A、Year(Now())-Year(‘出生年月’)
B、Now()-Year(#出生年月#)
C、Year(Now())-Year([出生年月])
D、Now()-Year(“出生年月”)
【正确答案】:C
