Combine SQL Expression/Text with field?

#1

Is there a way to combine a SQL expression with a field.
For example: to_date(dateField, yyyy-mm-dd)

Or is it possible to write a field without a comma afterwards.
For example:
Field without Comma: to_date(
Field without Comma: dateField
Field: )

So in the Insert Statement will be written:
insert into MOCK_DATA (FirstName, LastName, Birthdate, Country) values (‘Walter’, ‘Riley’, to_date(‘1982-11-20’, yyyy-mm-dd), Japan);

#2

Yes, you can use the code(string) function in the Formula type:

code("to_date('#{date}', yyyy-mm-dd)")

Here is an example schema: http://mockaroo.com/fae6eff0

1 Like