Import birthdays from phpbb => vB

[toddos]

Hi there,
how can I import the database field "user_birthday" from phpbb to vB without importing the complete table users ?

I imported all users, but now i have to import the birthdays again because i deleted them -.-

Is there a SQL Query or something else ?

[Kungfu]

not sure how its setup on phpbb but in vb its month-day-year

mm-dd-yyyy

BACKUP YOUR DATABASE FIRST.
but you can do something like

update vbusertable, phpbbusertable
set vbusertable.birthday = phpbbusertable.birthdaycolumn
where vbusertable.userid = phpbbusertable.useridcolumn

if you transferred data from phpbb to vb and its basically the same that should work. But im not 100% sure.

[toddos]

ok.
in phpbb birthday field is:
INT , Length: 11, null: not nul,l standard: 999999

in vBulletin birthday field is:
VARCHAR, length: 10, Collation: latin1_swedish_ci, Null: not null

and in phpbb omg i dont know what that:
i am born on october, 27th, 1988 and in the databse on my profile it views: "6874" in field of birthday.
6874 means october, 27th, 1988 ??

[toddos]

Kungfu, can you help me again? :)

[toddos]

need help plz

[toddos]

plz can help someone