sql.sql

> 
> `DECLARE @pathName NVARCHAR(512) 
>  SET @pathName = 'l:\Backup\db_backup_' + Convert(varchar(17), GETDATE(), 120) + '.bak' 
>  BACKUP DATABASE mydatabase TO DISK = @pathName WITH NOFORMAT, NOINIT, NAME = N'db_backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10`
> 
> 
> 

backup.bat

```
sqlcmd -S mycomp\SQLEXPRESS -U sa -P password -i sql.sql

```

Output backup format look like : **l:\Backup\db\_backup\_2014-05-22 17** ??
Why are not displayed Minutes,seconds and extensions ".bak" . I need to displayed date and time in a format : YYYY-MM-DD HH-MM-SS. Thanks for Answers.