Tabla de Contenidos
- ā OpciĆ³n: 1 |š MM/DD/YYYY
- ā OpciĆ³n: 2 |š YY.MM.DD
- ā OpciĆ³n: 3 |š DD/MM/YY
- ā OpciĆ³n: 4 |š DD.MM.YY
- ā OpciĆ³n: 5 |š DD-MM-YY
- ā OpciĆ³n: 6 |š DD MMM YY
- ā OpciĆ³n: 7 |š MMM DD,YY
- ā OpciĆ³n: 8 |š hh:mm:ss
- ā OpciĆ³n: 9 |š MMM DD YYYY hh:mm:ss:mmm(AM/PM)
- ā OpciĆ³n: 10 |š MM-DD-YY
- ā OpciĆ³n: 11 |š YY/MM/DD
ā OpciĆ³n: 1 |š MM/DD/YYYY
![](https://nodoyaro.com/wp-content/uploads/2022/12/image-2.png)
SQL
-- Standard: U.S.A
declare @TuFecha datetime
Set @TuFecha=GETDATE()
Select CONVERT(varchar,@TuFecha,1) as [MM/DD/YY]
ā OpciĆ³n: 2 |š YY.MM.DD
![](https://nodoyaro.com/wp-content/uploads/2022/12/image-3.png)
SQL
-- Standard: ANSI
declare @TuFecha datetime
Set @TuFecha=GETDATE()
Select CONVERT(varchar,@TuFecha,2) as [YY.MM.DD]
ā OpciĆ³n: 3 |š DD/MM/YY
![](https://nodoyaro.com/wp-content/uploads/2022/12/image-6.png)
SQL
-- Standard: British/French
declare @TuFecha datetime
Set @TuFecha=GETDATE()
Select CONVERT(varchar,@TuFecha,3) as [DD/MM/YY]
ā OpciĆ³n: 4 |š DD.MM.YY
![](https://nodoyaro.com/wp-content/uploads/2022/12/image-5.png)
SQL
-- Standard: German
declare @TuFecha datetime
Set @TuFecha=GETDATE()
Select CONVERT(varchar,@TuFecha,4) as [DD.MM.YY]
ā OpciĆ³n: 5 |š DD-MM-YY
![](https://nodoyaro.com/wp-content/uploads/2022/12/image-4.png)
SQL
-- Standard: Italian
declare @TuFecha datetime
Set @TuFecha=GETDATE()
Select CONVERT(varchar,@TuFecha,5) as [DD-MM-YY]
ā OpciĆ³n: 6 |š DD MMM YY
![](https://nodoyaro.com/wp-content/uploads/2022/12/image-7.png)
SQL
-- Standard: Shortened month name
declare @TuFecha datetime
Set @TuFecha=GETDATE()
Select CONVERT(varchar,@TuFecha,6) as [DD MMM YY]
ā OpciĆ³n: 7 |š MMM DD,YY
![](https://nodoyaro.com/wp-content/uploads/2022/12/image-8.png)
SQL
-- Standard: Shortened month name
declare @TuFecha datetime
Set @TuFecha=GETDATE()
Select CONVERT(varchar,@TuFecha,7) as [MMM DD,YY]
ā OpciĆ³n: 8 |š hh:mm:ss
![](https://nodoyaro.com/wp-content/uploads/2022/12/image-9.png)
SQL
-- Standard: 24 hour time
declare @TuFecha datetime
Set @TuFecha=GETDATE()
Select CONVERT(varchar,@TuFecha,8) as [hh:mm:ss]
ā OpciĆ³n: 9 |š MMM DD YYYY hh:mm:ss:mmm(AM/PM)
![](https://nodoyaro.com/wp-content/uploads/2022/12/image-10.png)
SQL
-- Standard: Default + milliseconds
declare @TuFecha datetime
Set @TuFecha=GETDATE()
Select CONVERT(varchar,@TuFecha,9) as [MMM DD YYYY hh:mm:ss:mmm(AM/PM)]
ā OpciĆ³n: 10 |š MM-DD-YY
![](https://nodoyaro.com/wp-content/uploads/2022/12/image-11.png)
SQL
-- Standard: USA
declare @TuFecha datetime
Set @TuFecha=GETDATE()
Select CONVERT(varchar,@TuFecha,10) as [MM-DD-YY]
ā OpciĆ³n: 11 |š YY/MM/DD
![](https://nodoyaro.com/wp-content/uploads/2022/12/image-12.png)
SQL
-- Standard: JAPAN
declare @TuFecha datetime
Set @TuFecha=GETDATE()
Select CONVERT(varchar,@TuFecha,11) as [YY/MM/DD]