E-mail Print PDF

FORMAT ()

Синтаксис SQL FORMAT ()

SELECT FORMAT(column_name,format) FROM table_name

Description
column_name
format

Пример SQL FORMAT ()

Prod_IdUnit
1 Jarlsberg 1000 g 10.45
2 1000 g 32.56
3 1000 g 15.67

1
2
SELECT , , FORMAT(Now(),) as PerDate
FROM Products

Query Result:

PerDate
Jarlsberg 10.45
32.56
15.67

Authorization

Nice Ajax Poll

Which one of my extensions is the best?

Statistics

Translate

русскийitalianoDeutschEnglishLATVIANукраїнськаfrançaispolski
1

Advertisement