Update Data Extension with SQL Marketing Cloud

Question

I have a data extension (Name: Factura_T_Alex) with a single primary key (Name: NrFactura) and an attribute (Name: DataEmitere) which is a DateTime type. I need only the date part to use in a script so I created a Text type attribute (Name: DataEmitereText) in which I want to save only the date from DataEmitere so I wrote the folowing SQL Query:

SELECT
NrFactura,
CONVERT(varchar, DataEmitere, 101) AS DataEmitereText
FROM [Factura_T_Alex]

and IT WORKS!

But the targeted data extension for this is the same data extension I'm using in the SQL Query Activity, Factura_T_Alex, as seen in the image below.

My question is: Can I do that? Can I use the target data extension to update it's own fields in SQL and be sure that nothing will go wrong here? Like a field being written with the wrong value?

Answer 1

Going from your reply, you only need records for a certain day.

You could add the following WHERE-clause to your SQL query without the need to convert your date field:

WHERE Date(DataEmitere) = DATE(today())

For performance reasons, I would not recommend to convert your date field to text if you want to filter on it.