Sql Server Getdate() Does Not Return Default

[peterlaursen]

Sergio has asked this question in the FAQ's

“No SQL Server utilizo a função getdate() no “defalt value” para retornar a data atual e definí-la como valor padrão de um campo data. Como fazer no MySQL/SQLYog?”

I understand so much that it is a problem “that SQL server getdate() does not return default”. Who would translate exactly? And how does this relate to SQLyog.

I have sent a mail to Sergio with a link to this Forum entry

[Ritesh]

Can somebody tell me which language is that?

I used Google Language tool to convert the text from Spanish to English but it did not return any human understandable result (atleast to me).

[peterlaursen]

Undoubtedly it is Portuguese (as I wrote 😀 )

These accents tell

Quote:

função

[Ritesh]

Google language tool says:

“In the SQL Server I use the function getdate() in “defalt value” to return the current date and to define it as value standard of a field dates. How to make in the MySQL/SQLYog?”

I think he requires the MySQL function: date()

[Ritesh]

As an addition, I would like to say that this option is not available in Create/Alter Table dialog of SQLyog. Currently, we dont support inbuilt MySQL functions for default value.

Maybe, I should put it in the TO-DO list of SQLyog <_<

[peterlaursen]

There is no System Variable to use instead ?

default CURRENT_DATE or something like it ?

[peterlaursen]

I believe the solution with MySQL is to use a TIMESTAMP variable with “default CURRENT_TIMESTAMP” with the column definition.

The date is then created from this variable with the date() function. like:

select date(column_name) from table_name;

[peterlaursen]

now Sergio asks:

Quote:

Tive que reinstalar o software porém perdi a chave de liberação como faço para conseguir uma nova

[Author]

Posts